Re: NOT IN (NULL) ?

From: "Paul" <magamos(at)mail(dot)ru>
To: pgsql-general(at)postgresql(dot)org
Subject: Re: NOT IN (NULL) ?
Date: 2010-10-31 16:53:46
Message-ID: 552970079.20101031215346@mail.ru
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Pavel Stehule 2010-10-31 17:08:16 Re: NOT IN (NULL) ?
Previous Message Raymond O'Donnell 2010-10-31 16:44:01 Re: NOT IN (NULL) ?