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: | Raw Message | Whole Thread | 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
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 |