Lists & arrays Scalar

list_concat()

Concatenates two lists.

Arguments & returns

Scalar

Overload link	… Varargs	Returns
#01	`ANY[]`	`ANY[]`

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

SELECT list_concat([2, 3], [4, 5, 6], [7]);

Haybarn WASM 1.5.5-rc3 · In your browser

Engine example · Run to view results.

SELECT
  list_concat([2, 3], [4, 5, 6]);

ARRAY_CAT(ARRAY[1, 2], ARRAY[3, 4])

In DuckDB

LIST_CONCAT([1, 2], [3, 4])

ARRAY_CONCAT([1, 2], [3, 4])

In DuckDB

LIST_CONCAT([1, 2], [3, 4])

ARRAY_CAT([1, 2], [3, 4])

In DuckDB

LIST_CONCAT([1, 2], [3, 4])

Used in larger rewrites 1

These examples use list_concat as one part of a larger SQL translation.

ARRAY_INSERT(ARRAY(1, 2, 3), 1, 99)

In DuckDB

CASE WHEN [1, 2, 3] IS NULL THEN NULL ELSE LIST_CONCAT([99], [1, 2, 3]) END