NULL in IN clause

From: Havasvölgyi Ottó <h(dot)otto(at)freemail(dot)hu>
To: <pgsql-sql(at)postgresql(dot)org>
Subject: NULL in IN clause
Date: 2005-10-19 20:17:34
Message-ID: 001a01c5d4ea$243a1830$6400a8c0@OTTO
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-sql

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

In response to

  • Re: at 2005-10-19 00:30:03 from Scott Marlowe

Responses

Browse pgsql-sql by date

  From Date Subject
Next Message Terry Fielder 2005-10-19 20:41:48 Re: NULL in IN clause
Previous Message Muralidharan Ramakrishnan 2005-10-19 18:33:02 Re: Problem -Postgre sql