MERGE(...)

All functions > ROW > MERGE(...)

Merges multiple row structures into a single row with combined fields

Syntax

MERGE(row, row, ...)

MERGE(row, row, ...)

Notes

• Requires at least 2 rows to merge
• All field names must be unique across all rows
• Fields are combined in order from left to right
• Throws error if duplicate field names exist

Examples

SELECT
    f1 := MERGE(ROW(1 AS col1, 'a' AS col2), ROW(1E0 AS col3, TRUE AS col4)), -- Merge two rows with different fields
    f2 := MERGE(ROW(1 AS col1, 'a' AS col2), ROW(1E0 AS col3, TRUE AS col4), ROW(1 AS col5)) -- Merge three rows
;