Sort
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.
attribute with Numeric, Point or bool value type
5.15
attribute 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
