Functions / Aggregate Functions

array_agg

Collects all the input values, including nulls, into an array.

Reading PG 18current·documented in 19 of 27 versions, 8.4 to 20

7.1 7.2 7.3 7.4 8.0 8.1 8.2 8.3 8.4 9.0 9.1 9.2 9.3 9.4 9.5 9.6 10 11 12 13 14 15 16 17 18 19 20

Signatures & examples

array_agg ( anynonarray ORDER BY input_sort_columns ) → anyarray

Collects all the input values, including nulls, into an array.

array_agg ( anyarray ORDER BY input_sort_columns ) → anyarray

Concatenates all the input arrays into an array of one higher dimension. (The inputs must all have the same dimensionality, and cannot be empty or null.)

Version history 5

16 → 17 changed
12 → 13 changed
9.4 → 9.5 changed
8.4 → 9.0 changed
8.3 → 8.4 added

Definition snapshot: b7bd9cda · English manual source