Description
Concatenates the string arguments to the calling string using a separator (JavaScript Join function Documentation).
Sample Source Pattern
Syntax
Array.join( separator )
Arguments
separator: Character to join.
Return Type
String.
Examples
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|
