ordering-functions Sort


  • sort(a)


The sort(a) function sorts a numeric, point or boolean attribute in an numeric ascending order.

  • null values become the first elements in the resulting order
  • in boolean items False values are sorted before True values
  • in two-dimensional data items, the sort order is based on the first coordinate.

The sort_str function sort string attributes in alphabetic order.

applies to

attribute with Numeric, Point or bool value-type


attribute<float32> sortA (CDomain) := sort(A);
A sortA
0 null
1 null
2.5 null
-100 -100
999 0
null 0
null 1
0 2.5
null 100
100 999

CDomain, nr of rows = 10

see also