Skip to content

max_elem_alldefined

mtbeek32 edited this page Jan 31, 2024 · 8 revisions

Ordering functions maximum element alldefined

syntax

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

definition

max_elem_alldefined(a, b, .. , n) is a variant of the max_elem function resulting in defined values if all values of the arguments for an entry in the domain unit are defined. If any argument contains null values, the resulting value for that entry will be become null.

since version

8.6.5

example

attribute<uint32> max_elem_alldefinedABC (MDomain) := max_elem_alldefined(A, B, C);
A(int32 B(int32) C(int32) max_elem_alldefinedABC
0 1 2 2
1 -1 4 4
-2 2 2 2
4 0 7 7
999 111 -5 999
2 null 1 null
0 1 null null
null 1 2 null
null null null null

MDomain, nr of rows = 9

see also

Clone this wiki locally