ARRAY_AGG function [Aggregate]

Creates an unbounded, single-dimensional array from the specified expression for each group where the array element type is identical to the specified expression.

Syntax

ARRAY_AGG( expression
[ ORDER BY order-by-expression [ ASC | DESC ], ... ] )

Parameters

expression The expression to base the array on.
The array is created with the first element having the value of the first group from expression, the second element having the value of the second group, and so on.
s A set of attributes that indicate how sort the rows returned by the expression.

Remarks

Array elements are filled from the input beginning with the first element.

ARRAY_AGG does not ignore NULL values in its input. NULL values are stored in the array as separate elements like any other value. If the group is empty, the result of the ARRAY_AGG function contains a NULL element for that group.

ARRAY_AGG cannot be used as a window function, but it can be used as an input to a window function.

The UNNEST array operator can be used to create a series of rows from an array to process each array element with other relational expressions.

Standards and compatibility

Discuss this page in DocCommentXchange.