Re: Query about Boolean Data Type

"Richard Hurst" <richard.hurst@kirklees.gov.uk> writes:
> This may seem a bit simplistic but how do you match a select on a
> boolean data column where the entry is false or null

Slick way:
        ... WHERE foo IS NOT TRUE;
Straightforward way:
        ... WHERE (NOT foo) OR (foo IS NULL);
or
        ... WHERE (foo = false) OR (foo IS NULL);
but not
        ... WHERE (foo = false) OR (foo = NULL);
The last will not do what you expect.

            regards, tom lane