Postgres Pro
Downloads
Home   >   mailing lists

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

From Peter Eisentraut
Subject Re: select, where and null-values (or: select null<>'1' is fuzzy)
Date
Msg-id Pine.LNX.4.30.0106122021230.756-100000@peter.localdomain
Whole thread Raw
In response to select, where and null-values (or: select null<>'1' is fuzzy)  (Peter Pilsl <pilsl@goldfisch.at>)
List pgsql-general
Tree view 
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

pgsql-general by date:

Previous
From: GH
Date:
Subject: Re: Re: [SQL] maximum number of rows in table - what about oid limits?
Next
From: "Thalis A. Kalfigopoulos"
Date:
Subject: Re: select, where and null-values (or: select null<>'1' is fuzzy)