Boolean operators

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:

Results of NOT operations:
Value of x Result of NOT x
TRUE FALSE
FALSE TRUE
NULL NULL
Results of AND operations:
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
Results of OR operations:
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.