pg.ddx.io  pgsql-sql@postgresql.org mailing list archive  
help / color / mirror / Atom feed
From: Stephan Szabo <sszabo@megazone23.bigpanda.com>
To: Markus Bertheau <twanger@bluetwanger.de>
Cc: postgres sql list <pgsql-sql@postgresql.org>
Subject: Re: no cond returns diff res than cond or !cond
Date: Mon, 12 Nov 2001 06:39:50 -0800 (PST)
Message-ID: <20011112063643.M74385-100000@megazone23.bigpanda.com> (raw)
In-Reply-To: <1005575205.31390.2.camel@entwicklung01.cenes.de>

On 12 Nov 2001, Markus Bertheau wrote:

> cenes_test=> select version();
>                            version
> -------------------------------------------------------------
>  PostgreSQL 7.1.3 on i686-pc-linux-gnu, compiled by GCC 2.96
> (1 row)
>
> cenes_test=> select count(*) from produkte;
>  count
> -------
>  36384
> (1 row)
>
> cenes_test=> select count(*) from produkte where artnummer = NULL or
> artnummer != NULL;
>  count
> -------
>  36326
> (1 row)
>
> 2nd query 58 less than first.
>
> bug?

Probably not.  You don't want to compare to NULL (although there is a
hack which makes an explicit = NULL into the correct comparison), you
want to use IS NULL and IS NOT NULL.  Comparing to NULL returns an
unknown (neither true nor false) and negating that comparison still
returns unknown.  The hack is in there for compatibility with an
MS Access feature, and I think is optional in 7.2, and turns = NULL
into IS NULL, there's no equivalent hack for != NULL AFAIK.





view thread (3+ messages)  latest in thread

Message-ID: <20011112063643.M74385-100000@megazone23.bigpanda.com>
Permalink:  ../20011112063643.M74385-100000@megazone23.bigpanda.com/
Also on:    postgresql.org/message-id/20011112063643.M74385-100000@megazone23.bigpanda.com

 · 

reply

Reply instructions:

You may reply publicly to this message via plain-text email
using any one of the following methods:

* Reply to all the recipients using the --to and --cc options:
  reply via email

  To: pgsql-sql@postgresql.org
  Cc: sszabo@megazone23.bigpanda.com, twanger@bluetwanger.de
  Subject: Re: no cond returns diff res than cond or !cond
  In-Reply-To: <20011112063643.M74385-100000@megazone23.bigpanda.com>

* Save the following mbox file, import it into your mail client,
  and reply-to-all from there: mbox

This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox