Boolean

A BOOLEAN column is one that contains values that are either true or false. A BOOLEAN constant is, therefore, defined as follows.

boolean:
               {TRUE | 1} | {FALSE | 0}

select * from mytypes where is_smart = true and is_married = 0;