Home > mailing lists

NULL in IN clause - Mailing list pgsql-sql

From	Havasvölgyi Ottó
Subject	NULL in IN clause
Date	October 19, 2005 20:19:20
Msg-id	001a01c5d4ea$243a1830$6400a8c0@OTTO Whole thread Raw
In response to	("Shavonne Marietta Wijesinghe" <shavonne.marietta@studioform.it>)
Responses	Re: NULL in IN clause Re: NULL in IN clause Re: NULL in IN clause Re: NULL in IN clause
List	pgsql-sql

Tree view

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

pgsql-sql by date:

From: Muralidharan Ramakrishnan
Date: 19 October 2005, 18:34:55
Subject: Re: Problem -Postgre sql

From: Terry Fielder
Date: 19 October 2005, 20:36:00
Subject: Re: NULL in IN clause

NULL in IN clause - Mailing list pgsql-sql

Previous

Next