Re: The empty list? - Mailing list pgsql-sql

From Tom Lane
Subject Re: The empty list?
Date
Msg-id 27240.1162537345@sss.pgh.pa.us
Whole thread Raw
In response to Re: The empty list?  (Jesper Krogh <jesper@krogh.cc>)
List pgsql-sql
Jesper Krogh <jesper@krogh.cc> writes:
> Tom Lane wrote:
>> FWIW, as of 8.2 the best option will probably be to use
>> "col = ANY (array)", which does support zero-length arrays
>> if you use either an out-of-line parameter or an array literal.

> That looks nice.. is ANY in the SQL-spec?

ANY is, but I think only in the form "var = ANY (SELECT ...)".
        regards, tom lane


pgsql-sql by date:

Previous
From: Tom Lane
Date:
Subject: Re: delete and select with IN clause issues
Next
From: Jeff Frost
Date:
Subject: Re: delete and select with IN clause issues