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.
| 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®.