Materialize Logo

boolean Data Type

boolean data expresses a binary value of either TRUE or FALSE.

Detail Info
Quick Syntax TRUE or FALSE
Size 1 byte
Aliases bool

Syntax

TRUE FALSE

Details

Valid casts

From boolean

You can cast boolean to:

To boolean

You can cast the following types to boolean:

Examples

SELECT TRUE AS t_val;
 t_val
-------
 t

```sql SELECT FALSE AS f_val; ``` ```nofmt f_val ------- f ```