Last updated 1 year ago
Concatenates the string arguments to the calling string using a separator ().
Array.join( separator )
separator: Character to join.
separator
String.
String
CREATE OR REPLACE FUNCTION join_strs(separator varchar, strings array) RETURNS string LANGUAGE JAVASCRIPT AS $$ return STRINGS.join(SEPARATOR); $$; SELECT join_strs(' ',array_construct('Mariah','Carey')) NAME;
NAME| ------------+ Mariah Carey|