In SQL all logical operators evaluate to TRUE, FALSE or NULL (UNKNOWN). Gladius implements these values as as 1 (TRUE), 0 (FALSE), and NULL. NULL values are
implicitly converted to 0 (FALSE).
NOT
Logical NOT. Evaluates to TRUE (1) if the operand is FALSE (0), to FALSE (0) if the
operand is non-zero
AND
Logical AND. Evaluates to TRUE (1) if all operands are non-zero, to FALSE (0) if one
or more operands are FALSE (0)
OR
Logical OR. The result is TRUE (1) if any operand is non-zero and FALSE (0)
otherwise.