Postgres Pro
Downloads
Home   >   mailing lists

NULL in IN clause - Mailing list pgsql-sql

From Havasvölgyi Ottó
Subject NULL in IN clause
Date
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  (Terry Fielder <terry@ashtonwoodshomes.com>)
Re: NULL in IN clause  (David Dick <david_dick@iprimus.com.au>)
Re: NULL in IN clause  (Tom Lane <tgl@sss.pgh.pa.us>)
Re: NULL in IN clause  (Stephan Szabo <sszabo@megazone.bigpanda.com>)
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:

Previous
From: Muralidharan Ramakrishnan
Date:
Subject: Re: Problem -Postgre sql
Next
From: Terry Fielder
Date:
Subject: Re: NULL in IN clause