The BOOLEAN data type is a 1-byte data type. The legal values for Boolean are true ('t'), false ('f'), or NULL. The values are not case sensitive.
You can compare a BOOLEAN column against another BOOLEAN column or against Boolean values. For example, you might use these SELECT statements:
SELECT * FROM sometable WHERE bool_col = 't'; SELECT * FROM sometable WHERE bool_col IS NULL;