Re: NOT IN (NULL) ? - Mailing list pgsql-general

From Paul
Subject Re: NOT IN (NULL) ?
Date
Msg-id 552970079.20101031215346@mail.ru
Whole thread Raw
In response to Re: NOT IN (NULL) ?  (Tom Lane <tgl@sss.pgh.pa.us>)
Responses Re: NOT IN (NULL) ?  (Pavel Stehule <pavel.stehule@gmail.com>)
Re: NOT IN (NULL) ?  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-general
Tom,

Sunday, October 31, 2010, 9:42:27 PM, you wrote:

TL> Because the SQL standard says so.

But  there  is  not  such  thing  in PostgreSQL as empty set as "IN ()" that must be
false, because nothing element may be found in empty set.
And  I  thought that instead of "IN ()" I could use "IN (NULL)", but I
was failed and result was NULL and not FALSE. :(

--
Paul


pgsql-general by date:

Previous
From: Raymond O'Donnell
Date:
Subject: Re: NOT IN (NULL) ?
Next
From: Pavel Stehule
Date:
Subject: Re: NOT IN (NULL) ?