ZIP(...)

All functions > ARRAY OF ROWS > ZIP(...)

Combines multiple arrays into a single array of structured rows with named fields.

Syntax

ZIP(array [ AS field_name ] [, array [ AS field_name ] ...])

ZIP(array [ AS field_name ] [, array [ AS field_name ] ...])

Notes

• Combines arrays element-by-element into rows
• Uses longest array length, pads shorter arrays with NULL
• Can specify custom field names with AS clause
• Default field names are field_1, field_2, etc.
• Generic type: (Array(T1), Array(T2), ...) → Array(Row(field_1: T1, field_2: T2, ...))

See also

• Array functions

• Array-of-rows functions

Examples

SELECT
    f1 := ZIP(ARRAY[1, 2, 3]), -- Zip single array into rows
    f2 := ZIP(ARRAY[1, 2, 3], ARRAY['a', 'b', 'c']), -- Zip two arrays into rows
    f3 := ZIP(ARRAY[1, 2, 3], ARRAY['a', 'b']) -- Zip arrays of different lengths
;