Skip to content

boolean.md

Latest commit

 

History

History
168 lines (142 loc) · 2.23 KB

boolean.md

File metadata and controls

168 lines (142 loc) · 2.23 KB

Boolean Operations

There are two Boolean literals: TRUE and FALSE.

We support the following Boolean operations:

OR

The following truth table defines the OR operator:

TRUE FALSE NULL
TRUE TRUE TRUE TRUE
FALSE TRUE FALSE NULL
NULL TRUE NULL NULL

AND

The following truth table defines the AND operator:

TRUE FALSE NULL
TRUE TRUE FALSE NULL
FALSE FALSE FALSE FALSE
NULL NULL FALSE NULL

NOT

The following table defines the NOT operator:

TRUE FALSE
FALSE TRUE
NULL NULL

IS FALSE

The following table defines the IS FALSE operator:

TRUE FALSE
FALSE TRUE
NULL FALSE

IS NOT FALSE

The following table defines the IS NOT FALSE operator:

TRUE FALSE
FALSE TRUE
NULL TRUE

IS TRUE

The following table defines the IS TRUE operator:

TRUE TRUE
FALSE FALSE
NULL FALSE

IS NOT TRUE

The following table defines the IS NOT TRUE operator:

TRUE FALSE
FALSE TRUE
NULL TRUE

:::info

Notice that not all Boolean operations produce NULL results when an operand is NULL.