Join in JS
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;
Last updated
Was this helpful?