Home
User Guides
  1. OPAL Reference
  2. OPAL functions and verbs
  3. OPAL Functions

sort_array

sort_array(input_array: array, [options(...)]?) -> input_array

Return an array with the elements of the input array in sorted order.

sort_array accepts two options:

asc decides whether the elements are sorted in ascending order. Default is true (sort ascending).

nulls_first decides whether the NULLs are placed at the start or the end of the array. If nulls_first is not specified, NULLs are sorted last if asc is true or first if asc is false.

Options

OptionTypeMeaning
ascboolSorts the elements in ascending order if asc is true or in descending order if asc is false. Default is true (ascending).
nulls_firstboolNULLs are placed at the start of the array if nulls_first is true or at the end of the array if nulls_first is false. If nulls_first is not specified, NULLs are sorted last if asc is TRUE or first if asc is FALSE.

Domain

This is a scalar function (calculates a single output value for a single input row).

Categories

Examples

Make a new column sorted_arr, which contains the sorted elements in ascending order.

Make a new column sorted_arr, which contains the sorted elements in descending order.

Make a new column sorted_arr, which contains the sorted elements in ascending order and NULLs placed at the start of the sorted array.