Re: not null - trivial, unexpected behavior

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: john(at)august(dot)com
Cc: pgsql-sql(at)postgresql(dot)org
Subject: Re: not null - trivial, unexpected behavior
Date: 2001-06-16 16:21:16
Message-ID: 28069.992708476@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-sql

John Scott <jmscott(at)yahoo(dot)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

In response to

Browse pgsql-sql by date

  From Date Subject
Next Message Peter Eisentraut 2001-06-16 16:23:35 Re: not null - trivial, unexpected behavior
Previous Message Peter Eisentraut 2001-06-16 16:11:54 Re: not null - trivial, unexpected behavior