Received: from leela.one-2-one.net (leela.one-2-one.net [217.115.142.65]) by postgresql.org (8.11.3/8.11.4) with ESMTP id fACEEOm07010 for ; Mon, 12 Nov 2001 09:14:24 -0500 (EST) (envelope-from twanger@bluetwanger.de) Received: from [192.168.0.14] (pD9501247.dip.t-dialin.net [217.80.18.71]) by leela.one-2-one.net (8.11.0/8.11.0) with ESMTP id fACEDv200318 for ; Mon, 12 Nov 2001 15:13:57 +0100 Subject: no cond returns diff res than cond or !cond From: Markus Bertheau To: postgres sql list Content-Type: text/plain Content-Transfer-Encoding: 7bit X-Mailer: Evolution/0.99.0 (Preview Release) Date: 12 Nov 2001 15:26:44 +0100 Message-Id: <1005575205.31390.2.camel@entwicklung01.cenes.de> Mime-Version: 1.0 X-Archive-Number: 200111/153 X-Sequence-Number: 5537 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