FunctionsArray

array_all

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

array_all(…) → Bool

Kind · scalar

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

Part of the Array family.

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_append

Appends the provided value to the end of the input array and returns the resulting array.