Skip to content

boolean.md

Latest commit

 

History

History
171 lines (145 loc) · 2.41 KB

boolean.md

File metadata and controls

171 lines (145 loc) · 2.41 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

Casting a string to a Boolean value produces the result true for any string which spells 'true' when converted to lowercase. Any other non-null string produces the result false.

:::info

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