Ge
ordering-functions greater than or equals to (>=)
syntax
- ge(a, b)
- a >= b
definition
ge(a, b) or a > b results in a boolean data-item indicating if the values of data item a are greater than or equal to the corresponding values of data item b.
description
Each comparison with missing values results in the value false.
applies to
Data items with Numeric, string or bool value-type
conditions
- Domain of the arguments must match or be void (literals or parameters can be compared to data items of any domain).
- Arguments must have matching:
example
1. attribute<bool> AgeB (CDomain) := ge(A, B);
2. attribute<bool> AgeB (CDomain) := A >= B;
A | B | AgeB |
---|---|---|
0 | 0 | True |
1 | 2 | False |
2.5 | 2.5 | True |
-100 | 100 | False |
999 | -999 | True |
null | 0 | False |
null | null | False |
0 | null | False |
null | 100 | False |
100 | null | False |
CDomain, nr of rows = 10