Skip to content

SQL Boolean

Casting text to boolean

  • t, true, y, yes, on, 1
  • f, false, n, no, off, 0
select 'true'::boolean, 'false'::boolean;

 bool | bool
------+------
 t    | f
(1 row)

select 'a'::BOOLEAN;
-- ERROR:  invalid input syntax for type boolean: "a"
-- LINE 1: select 'a'::BOOLEAN;
Last update: 2023-04-24