Value construction functions

SQL Function Description

ROW(value1 [, value2]*)

Also valid as an implicit row constructor using parenthesis alone.

Returns a row created from a list of values (value1, value2, …​).

For example:

Returns

ROW(1 ,'FOO' )

(1 ,'FOO' )

The implicit row constructor requires at least two fields. The explicit row constructor can deal with an arbitrary number of fields. Both of them support arbitrary expressions as fields.

ARRAY[ value1 [, value2 ]* ]

Returns an array created from a list of values (value1, value2, …​).

For example:

Returns

ARRAY['A','B','C']

[A, B, C]

MAP[ value1, value2 [, value3, value4 ]* ]

Returns a map created from a list of key-value pairs ( (value1, value2), (value3, value4), …​ ).

For example:

Returns

MAP['A','B','C','D']

{A=B, C=D}