The operators in table 1 can be used in formulas.
Table 1. Operators in GoPhast FormulasOperator |
Meaning |
Data Types |
Result type |
---|---|---|---|
= |
equals |
real numbers, integers,
Booleans, text |
Boolean |
<> |
not equals |
real numbers, integers,
Booleans, text |
Boolean |
> |
greater than |
real numbers, integers,
Booleans, text |
Boolean |
< |
less than |
real numbers, integers,
Booleans, text |
Boolean |
>= |
greater than or equals |
real numbers, integers,
Booleans, text |
Boolean |
<= |
less than or equals |
real numbers, integers,
Booleans, text |
Boolean |
and |
and |
Booleans |
Boolean |
or |
or |
Booleans |
Boolean |
xor |
exclusive or |
Booleans |
Boolean |
not |
not |
Booleans |
Boolean |
mod |
modulus (remainder) |
integers |
integer |
div |
integer division |
integers |
integer |
* |
multiplication |
real numbers, integers |
real number, integer |
/ |
division |
real numbers, integers |
real number, integer |
+ |
addition or concatenation |
real numbers, integers, text |
real number, integer, text |
- |
subtraction |
real numbers, integers |
real number, integer |
The operator precedence rules are shown in table 2. Operators
of equal precedence are evaluated in left to right order.
Operators |
Precedence |
---|---|
() |
first (highest) |
not |
second |
and, mod, div, *, / |
third |
or, xor, +, - |
fourth |
=, <>, >, <, >=,
<= |
fifth (lowest) |