Skip to main content

Boolean Functions

Or

Substrait definition

Or implements the boolean logic Or operator. Its return value will always be a boolean. An argument into the Or function that is not a boolean will be the same as the boolean value false.

Implements Kleene logic with the following truth table:

+------+-------+-----+-----+-----+
| | **B** |
+ **A OR B** +-----+-----+-----+
| |**F**|**N**|**T**|
+------+-------+-----+-----+-----+
| | **F** | F | N | T |
+ +-------+-----+-----+-----+
|**A** | **N** | N | N | T |
+ +-------+-----+-----+-----+
| | **T** | T | T | T |
+------+-------+-----+-----+-----+

F = False, T = True, N = Null

SQL Usage

... WHERE c1 = 'hello' OR c2 = 'world'

And

Substrait definition

And implements the boolean logic And operator. Its return value will always be a boolean. An argument into the And function that is not a boolean will be the same as the boolean value false.

Implements Kleene logic with the following truth table:

+------+-------+-----+-----+-----+
| | **B** |
+ **A AND B** +-----+-----+-----+
| |**F**|**N**|**T**|
+------+-------+-----+-----+-----+
| | **F** | F | F | F |
+ +-------+-----+-----+-----+
|**A** | **N** | F | N | N |
+ +-------+-----+-----+-----+
| | **T** | F | N | T |
+------+-------+-----+-----+-----+

F = False, T = True, N = Null

SQL Usage

... WHERE c1 = 'hello' AND c2 = 'world'

Not

Substrait definition

The not of a boolean value. When a null is input, a null is output.

SQL Usage

... WHERE NOT c1 = 'hello'

Xor

Substrait definition

Xor implements the boolean logic Xor operator using kleene logic.

SQL Usage

... WHERE (c1 = 'hello') XOR (c2 = 'world')