Lists & arrays Scalar

concat()

Concatenates multiple strings or lists. NULL inputs are skipped. See also operator ||.

Arguments & returns

Scalar

Overload link	`value`	… Varargs	Returns
#01	`ANY`	`ANY`	`ANY`

… accepts a variable number of arguments of the type shown.

SELECT concat('Hello', ' ', 'World');

Haybarn WASM 1.5.5-rc3 · In your browser

Engine example · Run to view results.

SELECT concat([1, 2, 3], NULL, [4, 5, 6]);

Haybarn WASM 1.5.5-rc3 · In your browser

Engine example · Run to view results.