Background documentationBoolean Predicate (bool_predicate) Locate this document in the navigation structure

 

Boolean values (BOOLEAN) are compared in a Boolean predicate (bool_predicate).

Structure

Syntax Syntax

  1. <bool_predicate> ::=
      <column_spec> [IS [NOT] TRUE | IS [NOT] FALSE]
End of the code.
Explanation

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:

Boolean Predicate (bool_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