"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
