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

  1. Domain of the arguments must match or be void.
  2. 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

The result is null only where all arguments are null.

see also