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:

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