Jesper Krogh <[EMAIL PROTECTED]> 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 ---------------------------(end of broadcast)--------------------------- TIP 4: Have you searched our list archives? http://archives.postgresql.org