Re: select, where and null-values (or: select null<>'1' is fuzzy) - Mailing list pgsql-general

> I've a problem when selecting values out a table.

It's correct.  NULL<>1 is defined as NULL by the spec.
Where clauses only return rows that the expression is true
and so will not return the NULL row.

If you want the null rows to show up, you'll need to either
use coalesce or add or blah IS NULL to the expression.