MERGE_FUNC
All functions > ROW > MERGE_FUNC
Merges multiple row structures into a single row with combined fields
Syntax
MERGE_FUNC(expressions)sql
Arguments
| Parameter | Type | Required | Description |
|---|---|---|---|
expressions | ARRAYROW | Yes | Array of row expressions to merge |
Returns
ROW - A single row containing all fields from input rows
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