ERROR 3678:Invalid input syntax for varbinary

[Hemakumar Gantepalli]

Hi Gurus,

I am just started learning Vertica. I have executed the below query to find out the length of the string and this is given example in the Vertica. This below error has thrown SELECT LENGTH('vert\0ica'::BINARY VARYING);
ERROR 3678:Invalid input syntax for varbinary

Please let me know the correction and thanks in advance.

[JimKnicely]

Hi there!

What are you trying to do? Maybe you need to escape?

Code: Select all

dbadmin=> SELECT LENGTH('vert\\0ica'::BINARY VARYING);
 LENGTH
--------
      9
(1 row)

Or do something like this?

Code: Select all

dbadmin=> SELECT LENGTH('vert' || E'\0' || 'ica');
 LENGTH
--------
      8
(1 row)

I'm not sure what your intentions are