Received: from localhost (wm.hub.org [200.46.204.128]) by postgresql.org (Postfix) with ESMTP id 41FA79FB260 for ; Fri, 3 Nov 2006 03:02:32 -0400 (AST) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.204.128]) (amavisd-new, port 10024) with ESMTP id 25960-05 for ; Fri, 3 Nov 2006 07:02:30 +0000 (UTC) X-Greylist: from auto-whitelisted by SQLgrey- Received: from sss.pgh.pa.us (sss.pgh.pa.us [66.207.139.130]) by postgresql.org (Postfix) with ESMTP id C2E3F9FA4AD for ; Fri, 3 Nov 2006 03:02:28 -0400 (AST) Received: from sss2.sss.pgh.pa.us (tgl@localhost [127.0.0.1]) by sss.pgh.pa.us (8.13.6/8.13.6) with ESMTP id kA372PXW027241; Fri, 3 Nov 2006 02:02:25 -0500 (EST) To: Jesper Krogh cc: Aaron Bono , pgsql-sql@postgresql.org Subject: Re: The empty list? In-reply-to: <454AE5B5.4050106@krogh.cc> References: <454A654B.2000306@krogh.cc> <21991.1162506863@sss.pgh.pa.us> <454ADB6F.9070602@krogh.cc> <26899.1162535774@sss.pgh.pa.us> <454AE5B5.4050106@krogh.cc> Comments: In-reply-to Jesper Krogh message dated "Fri, 03 Nov 2006 07:46:13 +0100" Date: Fri, 03 Nov 2006 02:02:25 -0500 Message-ID: <27240.1162537345@sss.pgh.pa.us> From: Tom Lane X-Virus-Scanned: Maia Mailguard 1.0.1 X-Archive-Number: 200611/37 X-Sequence-Number: 26689 Jesper Krogh 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