Functions / Array Functions And Operators

array_sort

Sorts the first dimension of the array.

Reading PG 18current·documented in 3 of 27 versions, 18 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_sort ( array anyarray [, descending boolean [, nulls_first boolean ]] ) → anyarray

Sorts the first dimension of the array. The sort order is determined by the default sort ordering of the array's element type; however, if the element type is collatable, the collation to use can be specified by adding a COLLATE clause to the array argument.

array_sort(ARRAY[[2,4],[2,1],[6,5]]) → {{2,1},{2,4},{6,5}}

Version history 1

17 → 18 added

Definition snapshot: 2026-09-14T13:14:25.684213+00:00@99e6866c · English manual source