Gt

Ordering functions greater than (>)

syntax

1. gt(a, b)
2. a > b

definition

gt(a, b) or a > b results in a boolean data item indicating if the values of data item a are **greater than ** 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

1. Domain of the arguments must match or be void (literals or parameters can be compared to data items of any domain).
2. Arguments must have matching:
   • value type
   • metric

example

1. attribute<bool> AgtB (CDomain) := gt(A, B);
2. attribute<bool> AgtB (CDomain) := A > B;

A	B	AgtB
0	0	False
1	2	False
2.5	2.5	False
-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

see also

• greater than or equals