Aggregation functions
ARRAY_AGG
Reference material for ARRAY_AGG function
Concatenates input values, including NULL
values, into an array.
Syntax
Parameters
Parameter | Description | Supported input type |
---|---|---|
<expression> | Expression of any type to be accumulated into an array. | Any |
Return Type
ARRAY
of the same type as the input data. If there is no input data, ARRAY_AGG
returns NULL
.
Example
For the following example, see the player_information
table:
nickname | playerid |
---|---|
stephen70 | 1 |
burchdenise | 7 |
sabrina21 | NULL |
The following code example code selects the columns in the player_information
table and returns the values in two arrays, nicknames
and playerids
:
Returns
{'stephen70', 'burchdenise', 'sabrina21'}, {1, 7, NULL}
The following code example shows that if a filter is added to the query which rejects all rows, ARRAY_AGG
will return NULL
:
Returns
NULL, NULL