FunctionsArray

array_agg

Collects input values from the group into an array. If an ORDER BY is specified in the aggregation context, that order is used; otherwise the order is not guaranteed.

array_agg(…) → String

Kind · aggregate

Collects input values from the group into an array. If an ORDER BY is specified in the aggregation context, that order is used; otherwise the order is not guaranteed.

Part of the Array family.

array

Builds an array value for each row by taking the row values from all input arguments in order.

array_all

Evaluates every element of the input array and returns true only when all elements are truthy.