Skip to content

min_elem_ifdefined

Jip Claassens edited this page Jul 6, 2026 · 5 revisions

Ordering functions minimum element ifdefined

syntax

  • min_elem_ifdefined(a, b, .. , n)

definition

min_elem_ifdefined(a, b, .. , n) is a variant of the min_elem function resulting in defined values if any value of the arguments for an entry in the domain unit is defined. If all arguments contain null values, the resulting value for that entry will become null.

example

attribute<int32> min_elem_ifdefinedABC (MDomain) := min_elem_ifdefined(A, B, C);
A(int32) B(int32) C(int32) min_elem_ifdefinedABC
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

see also

Clone this wiki locally