Postgres Pro
Downloads
Home   >   mailing lists

Re: not null - trivial, unexpected behavior - Mailing list pgsql-sql

From Tom Lane
Subject Re: not null - trivial, unexpected behavior
Date
Msg-id 28069.992708476@sss.pgh.pa.us
Whole thread Raw
In response to not null - trivial, unexpected behavior  (John Scott <jmscott@yahoo.com>)
List pgsql-sql
Tree view 
John Scott <jmscott@yahoo.com> writes:
> select count(*) from A where b = null;      /* Returns 1, ok */
> select count(*) from A where b != null;     /* Returns 0 ... not ok! */

Uh ... there have been several threads about this just in the past
couple days.  See for example
http://www.ca.postgresql.org/mhonarc/pgsql-sql/2001-06/msg00102.html
and followups.
        regards, tom lane

pgsql-sql by date:

Previous
From: Peter Eisentraut
Date:
Subject: Re: not null - trivial, unexpected behavior
Next
From: Peter Eisentraut
Date:
Subject: Re: not null - trivial, unexpected behavior