EQL supports the Boolean operators AND
, OR
, and NOT
.
The results of Boolean operations (including the presence of NULL) is shown in the following tables:
Value of x | Result of NOT x |
---|---|
TRUE | FALSE |
FALSE | TRUE |
NULL | NULL |
Value of x | Value of y | Result of x AND y |
---|---|---|
TRUE | TRUE | TRUE |
TRUE | NULL | NULL |
TRUE | FALSE | FALSE |
NULL | TRUE | NULL |
NULL | NULL | NULL |
NULL | FALSE | FALSE |
FALSE | TRUE | FALSE |
FALSE | NULL | FALSE |
FALSE | FALSE | FALSE |
Value of x | Value of y | x OR y |
---|---|---|
TRUE | TRUE | TRUE |
TRUE | NULL | TRUE |
TRUE | FALSE | TRUE |
NULL | TRUE | TRUE |
NULL | NULL | NULL |
NULL | FALSE | NULL |
FALSE | TRUE | TRUE |
FALSE | NULL | NULL |
FALSE | FALSE | FALSE |
For information on order of operations, see Operator precedence rules.