picoSQL - Language reference manual

6.5) NULL predicate

This predicate verifies if an expression is null or not. The syntax is:

expression IS [NOT] NULL

NOT operator reverses the meaning of the condition.

In statndard SQL, this is the only way to verify if an expression has NULL value or not. PicoSQL instead returns TRUE also comparing two columns containing NULL value.