Logical data types

The only logical data type is boolean. A boolean field can store true, false, and null. The boolean data type is not standard SQL.

The following table describes the logical data type.
Table 1. Logical data types
Type Value Disk Usage
boolean (alias bool) With value true (t) or false (f). 1 byte
You can use the following words to specify booleans:
  • True or false
  • On or off
  • ‘0’ or ‘1’
  • “true’ or ‘false’
  • ‘t’ or ‘f’
  • ‘on’ or ‘off’
  • ‘yes’ or ‘no’
Restriction: Never use a boolean data type for distribution columns because your table would be distributed to only two data slices in the IBM® Netezza®.