If only one column specification (column_spec) is specified, the syntax is identical to <column_spec> IS TRUE. The column specification must always denote a column with the data type BOOLEAN.
The following rules apply to the result of a Boolean predicate:
Column Value |
IS TRUE |
IS NOT TRUE |
IS FALSE |
IS NOT FALSE |
---|---|---|---|---|
False |
False |
True |
True |
False |
Undefined |
Undefined |
Undefined |
Undefined |
Undefined |
True |
True |
False |
False |
True |