"Richard Hurst" <richard(dot)hurst(at)kirklees(dot)gov(dot)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