IS TRUE, IS FALSE, IS UNKNOWN Predicates
The IS Boolean operator behaves according to the following truth table:
That is:
• IS TRUE is true for a BOOLEAN TRUE.
• IS FALSE is true for a BOOLEAN FALSE.
• IS UNKNOWN is true for an unknown (NULL) value.
• Every other comparison is false.
When applied to row value expressions, all elements must test the same.