CONCAT
Description
Sample Source Pattern
Syntax
CONCAT ( string_value1, string_value2 [, string_valueN ] ) CONCAT( <expr1> [ , <exprN> ... ] )
<expr1> || <expr2> [ || <exprN> ... ]String.concat( expression1, ..., expressionN )Examples
SELECT CONCAT('Ray',' ','of',' ','Light') AS TITLE; TITLE|
------------+
Ray of Light| SELECT CONCAT('Ray',' ','of',' ','Light') AS TITLE;
SELECT 'Ray' || ' ' || 'of' || ' ' || 'Light' as TITLE; TITLE|
------------+
Ray of Light| CREATE OR REPLACE FUNCTION concatenate_strs(strings array)
RETURNS string
LANGUAGE JAVASCRIPT
AS
$$
var result = ""
STRINGS.forEach(element => result = result.concat(element));
return result;
$$;
SELECT concatenate_strs(array_construct('Ray',' ','of',' ','Light')) TITLE; TITLE|
------------+
Ray of Light| Last updated
Was this helpful?