NOT

This function isn’t in the updated function reference yet. The details below come from the previous docs, and the product team is confirming them.

Syntax

NOT <expr> Returns true if the value is false.

> select colA from table1 where NOT (colB = y);

The following truth table demonstrates the boolean output of AND and OR:

a	b	a AND b	a OR b
true	true	true	true
true	false	false	true
false	true	false	true
false	false	false	false

Last modified on November 3, 2026