Re: The empty list?

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: Jesper Krogh <jesper(at)krogh(dot)cc>
Cc: Aaron Bono <postgresql(at)aranya(dot)com>, pgsql-sql(at)postgresql(dot)org
Subject: Re: The empty list?
Date: 2006-11-03 07:02:25
Message-ID: 27240.1162537345@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-sql

Jesper Krogh <jesper(at)krogh(dot)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

In response to

Browse pgsql-sql by date

  From Date Subject
Next Message Jeff Frost 2006-11-03 07:10:50 Re: delete and select with IN clause issues
Previous Message Tom Lane 2006-11-03 06:58:08 Re: delete and select with IN clause issues