Search found 9 matches

by fane89
Fri Dec 14, 2018 9:32 am
Forum: Vertica Database Administration
Topic: Adding a new node to a single host cluster
Replies: 3
Views: 54296

Re: Adding a new node to a single host cluster

Hi,

does this still apply in 2018?
by fane89
Wed Mar 21, 2018 9:13 am
Forum: Vertica SQL Functions
Topic: Calling SQL functions and not allowing to throw error.
Replies: 0
Views: 14395

Calling SQL functions and not allowing to throw error.

Hello, when calling to_number() or to_timestamp() function and something goes wrong an exception is thrown. Is there a possiblity to return null instead of throwing an error? Like safe casting via ::! I thought maybe to write custom functions and catch those errors, but it cannot be done via CREATE ...
by fane89
Mon Mar 19, 2018 10:27 am
Forum: New to Vertica Database Development
Topic: Calling SQL functions and not allowing to throw error.
Replies: 0
Views: 17393

Calling SQL functions and not allowing to throw error.

Hello, when calling to_number() or to_timestamp() function and something goes wrong an exception is thrown. Is there a possiblity to return null instead of throwing an error? Like safe casting via ::! I thought maybe to write custom functions and catch those errors, but it cannot be done via CREATE ...
by fane89
Fri Aug 04, 2017 10:57 am
Forum: Vertica SQL Functions
Topic: Audit specific columns
Replies: 3
Views: 16865

Re: Audit specific columns

Thank You very much kind Sir :)

strange, there is nothing about it when i serach the docs - https://my.vertica.com/docs/8.1.x/HTML/ ... 8_1_0-Live
by fane89
Thu Aug 03, 2017 10:20 am
Forum: Vertica SQL Functions
Topic: Audit specific columns
Replies: 3
Views: 16865

Audit specific columns

Hello,

is there a way to AUDIT (https://my.vertica.com/docs/8.1.x/HTML/ ... ight=AUDIT) just some columns from a table? Or a diffrent approach to achive this?
by fane89
Thu Aug 03, 2017 10:16 am
Forum: Vertica Data Load
Topic: Loading data via COPY to a table without ksafty.
Replies: 4
Views: 52570

Re: Loading data via COPY to a table without ksafty.

Thanks, i will look into that.

Go to advanced search