Boolean data type

Vertica provides the standard SQL type BOOLEAN, which has two states: true and false.

Vertica provides the standard SQL type BOOLEAN, which has two states: true and false. The third state in SQL boolean logic is unknown, which is represented by the NULL value.

Syntax

BOOLEAN

Parameters

Valid literal data values for input are:

TRUE 't' 'true' 'y' 'yes' '1' 1
FALSE 'f' 'false' 'n' 'no' '0' 0

Notes

  • Do not confuse the BOOLEAN data type with Boolean operators or the Boolean predicate.

  • The keywords TRUE and FALSE are preferred and are SQL-compliant.

  • A Boolean value of NULL appears last (largest) in ascending order.

  • All other values must be enclosed in single quotes.

  • Boolean values are output using the letters t and f.

See also