BOOL data type stores a Boolean value of false or true.
Aliases
In CockroachDB,BOOLEAN is an alias for BOOL.
Syntax
There are two predefined named constants forBOOL: TRUE and FALSE (the names are case-insensitive).
Alternately, a boolean value can be obtained by coercing a numeric value: zero is coerced to FALSE, and any non-zero value to TRUE.
CAST(0 AS BOOL)(false)CAST(123 AS BOOL)(true)
Size
ABOOL value is 1 byte in width, but the total storage size is likely to be larger due to CockroachDB metadata.
Examples
Supported casting and conversion
BOOL values can be cast to any of the following data types:

