max_elem_alldefined
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