Tom Lane wrote:
> Jesper Krogh <jesper@krogh.cc> writes:
>> ... the right-hand-side of on
>> in operation will allways be a list (if I havent forgotten something).
>
> IN (SELECT ...) for one thing.
Isn't that "just" a list of rows(complex value) instead of an list of
types(simple values)?
>> ... but missing SQL for the empty list basically means that
>> we cant handle the empty set encoded in the empty array without
>> explicitly introducing code for this size of array. From a
>> programatically viewpoint, this seems quite odd.
>
> 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?
Jesper
--
Jesper Krogh, jesper@krogh.cc