Unfortunately, if you try to concatenate more than two strings you’ll get an error:
Code: Select all
dbadmin=> SELECT concat('this', ' works');
concat
------------
this works
(1 row)
dbadmin=> SELECT concat('this', ' does not ', 'work');
ERROR 3457: Function concat(unknown, unknown, unknown) does not exist, or permission is denied for concat(unknown, unknown, unknown)
HINT: No function matches the given name and argument types. You may need to add explicit type casts
Code: Select all
dbadmin=> SELECT 'Vertica' || ' has' || ' a' || ' few' || ' quirks' Blasphemy;
Blasphemy
--------------------------
Vertica has a few quirks
(1 row)