BOOLEAN Type

AttentionThis page documents an earlier version. Go to the latest (v2.1)version.

Synopsis

BOOLEAN datatype is used to specify values of either true or false.

Syntax

  1. type_specification ::= BOOLEAN
  2. boolean_literal ::= TRUE | FALSE

Semantics

  • Columns of type BOOLEAN can be updated, inserted, and compared.
  • In WHERE clause, BOOLEAN columns can be used as a boolean expression.

See Also

Data Types