no cond returns diff res than cond or !cond

From: Markus Bertheau <twanger(at)bluetwanger(dot)de>
To: postgres sql list <pgsql-sql(at)postgresql(dot)org>
Subject: no cond returns diff res than cond or !cond
Date: 2001-11-12 14:26:44
Message-ID: 1005575205.31390.2.camel@entwicklung01.cenes.de
Views: Whole Thread | Raw Message | Download mbox | Resend email
Thread:
Lists: pgsql-sql

Good day,

feline=> select version();
version
---------------------------------------------------------------
PostgreSQL 7.0.2 on i686-pc-linux-gnu, compiled by gcc 2.95.2
(1 row)

feline=> select count(*) from produkte;
count
-------
36405
(1 row)

feline=> select count(*) from produkte where artnummer != NULL or
artnummer = NULL;
count
-------
36347
(1 row)

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?

Markus Bertheau

Responses

Browse pgsql-sql by date

  From Date Subject
Next Message Stephan Szabo 2001-11-12 14:39:50 Re: no cond returns diff res than cond or !cond
Previous Message Steve Brett 2001-11-12 13:40:10 Re: Optimizing