2010/10/31 Paul <[email protected]>: > 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. :( >
(NULL) isn't empty set. Empty set can be (SELECT 1 WHERE false) Regards Pavel > -- > Paul > > > -- > Sent via pgsql-general mailing list ([email protected]) > To make changes to your subscription: > http://www.postgresql.org/mailpref/pgsql-general > -- Sent via pgsql-general mailing list ([email protected]) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
