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

Peter Pilsl writes:

> manana=# select NULL<>'1';
>  ?column?
> ----------
>
> (1 row)
>
> This gives neither true nor false.

It gives NULL. This is correct three-valued Boolean logic.

--
Peter Eisentraut   peter_e@gmx.net   http://funkturm.homeip.net/~peter