X-Original-To: pgsql-sql-postgresql.org@localhost.postgresql.org
Received: from localhost (av.hub.org [200.46.204.144])
	by svr1.postgresql.org (Postfix) with ESMTP id 4968DDA57F
	for <pgsql-sql-postgresql.org@localhost.postgresql.org>;
	Wed, 19 Oct 2005 17:17:44 -0300 (ADT)
Received: from svr1.postgresql.org ([200.46.204.71])
	by localhost (av.hub.org [200.46.204.144]) (amavisd-new, port 10024)
	with ESMTP id 22759-01
	for <pgsql-sql-postgresql.org@localhost.postgresql.org>;
	Wed, 19 Oct 2005 20:17:41 +0000 (GMT)
Received: from viefep13-int.chello.at (viefep13-int.chello.at [213.46.255.15])
	by svr1.postgresql.org (Postfix) with ESMTP id 52E5CDA56A
	for <pgsql-sql@postgresql.org>; Wed, 19 Oct 2005 17:17:40 -0300 (ADT)
Received: from OTTO ([213.222.172.216]) by viefep13-int.chello.at
	(InterMail vM.6.01.04.04 201-2131-118-104-20050224) with SMTP
	id <20051019201741.PMOJ23665.viefep13-int.chello.at@OTTO>
	for <pgsql-sql@postgresql.org>; Wed, 19 Oct 2005 22:17:41 +0200
Message-ID: <001a01c5d4ea$243a1830$6400a8c0@OTTO>
From: =?iso-8859-2?Q?Havasv=F6lgyi_Ott=F3?= <h.otto@freemail.hu>
To: <pgsql-sql@postgresql.org>
References: <00cc01c5d00b$3a67dc70$1102a8c0@dream>
	<1129681803.15546.21.camel@state.g2switchworks.com>
Subject: NULL in IN clause
Date: Wed, 19 Oct 2005 22:17:34 +0200
MIME-Version: 1.0
Content-Type: text/plain; format=flowed; charset="iso-8859-2";
	reply-type=original
Content-Transfer-Encoding: 7bit
X-Priority: 3
X-MSMail-Priority: Normal
X-Mailer: Microsoft Outlook Express 6.00.2900.2527
X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2900.2527
X-Virus-Scanned: by amavisd-new at hub.org
X-Spam-Status: No, hits=0.021 required=5 tests=[AWL=-0.186,
	UPPERCASE_25_50=0.207]
X-Spam-Level: 
X-Archive-Number: 200510/224
X-Sequence-Number: 23077

Hi,

I have just run this command on 8.0.4 :

SELECT 'foo' WHERE 0 NOT IN (NULL, 1);

And it resulted is zero rows.
Without NULL it is OK.
Is this a bug, or the standard has such a rule?

Best Regards,
Otto