Min_elem
Ordering functions minimum element
syntax
- min_elem(a, b, .. , n)
definition
min_elem(a, b, .. , n) results in a Data item with the lowest value of the arguments in the element-by-element comparison.
The Domain unit of the resulting item is the same as the domain units of all arguments of the function.
The Values unit of the resulting item is the values unit of all arguments of the function.
applies to
Data items with Numeric or string value type
conditions
- Domain of the arguments must match or be void.
- Arguments must have matching:
example
attribute<uint32> min_elemABC (MDomain) := min_elem(A, B, C);
| A(int32) | B(int32) | C(int32) | min_elemABC |
|---|---|---|---|
| 0 | 1 | 2 | 0 |
| 1 | -1 | 4 | -1 |
| -2 | 2 | 2 | -2 |
| 4 | 0 | 7 | 0 |
| 999 | 111 | -5 | -5 |
| 2 | null | 1 | 1 |
| 0 | 1 | null | 0 |
| null | 1 | 2 | 1 |
| null | null | null | null |
MDomain, nr of rows = 9
In earlier versions (before 7.202) a null value in one of the arguments could result in a null value of the resulting data item. This now only occurs if all arguments have null values.