FunctionsArray

array_concat_agg

Concatenates array values from each row of the group into a single array, preserving row order within each partial aggregate.

array_concat_agg(…) → String

Kind · aggregate

Concatenates array values from each row of the group into a single array, preserving row order within each partial aggregate.

Part of the Array family.

array_concat

Concatenates all input arrays for each row into a single array preserving element order.

array_count

Counts array elements per row, or counts elements equal to the optional comparison value.