boolean type

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

Syntax

Details

Valid casts

From boolean

You can cast from boolean to:

• int (explicitly)
• text (by assignment)

To boolean

You can cast the following types to boolean:

• int (explicitly)
• jsonb (explicitly)
• text (explicitly)

Examples

SELECT TRUE AS t_val;

 t_val
-------
 t

SELECT FALSE AS f_val;
 f_val
-------
 f