Lists & arrays Scalar

array_zip()

Zips n LISTs to a new LIST whose length will be that of the longest list. Its elements are structs of n elements from each list list_1, …, list_n, missing elements are replaced with NULL. If truncate is set, all lists are truncated to the smallest list length.

Alias of list_zip()

Arguments & returns

`array_zip(…)`

Scalar

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

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

Example

2 more ↓

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

Haybarn WASM 1.5.5-rc3 · In your browser

Engine example · Run to view results.

More examples

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

Haybarn WASM 1.5.5-rc3 · In your browser

Engine example · Run to view results.

SELECT array_zip([1, 2], [3, 4], [5, 6, 7], true);

Haybarn WASM 1.5.5-rc3 · In your browser

Engine example · Run to view results.

Available in Haybarn 1.5 DuckDB 1.5 DuckDB 1.4 DuckDB 1.3