Received: from localhost (postgresql.org [64.49.215.8]) by postgresql.org (Postfix) with ESMTP id E704A475F31 for ; Tue, 8 Oct 2002 20:54:19 -0400 (EDT) Received: from gateway.heart.com.au (unknown [202.44.184.121]) by postgresql.org (Postfix) with ESMTP id AC445475D12 for ; Tue, 8 Oct 2002 20:54:17 -0400 (EDT) Received: from tardis.heart.com.au (IDENT:root@tardis.heart.com.au [192.168.0.42]) by gateway.heart.com.au (8.11.6/8.11.2) with ESMTP id g991TLI19689 for ; Wed, 9 Oct 2002 11:29:21 +1000 Received: from heart.com.au ([192.168.0.53]) by tardis.heart.com.au (8.9.3/8.8.7) with ESMTP id KAA14509 for ; Wed, 9 Oct 2002 10:53:59 +1000 Message-ID: <3DA37DAA.3090501@heart.com.au> Date: Wed, 09 Oct 2002 10:51:54 +1000 From: Keith Gray User-Agent: Mozilla/5.0 (Windows; U; Windows NT 5.0; en-US; rv:0.9.4.1) Gecko/20020508 Netscape6/6.2.3 X-Accept-Language: en-us MIME-Version: 1.0 To: pgsql-sql@postgresql.org Subject: Re: IN, EXISTS or ANY? References: Content-Type: text/plain; charset=us-ascii; format=flowed Content-Transfer-Encoding: 7bit X-Virus-Scanned: by AMaViS new-20020517 X-Archive-Number: 200210/115 X-Sequence-Number: 9832 Josh Berkus wrote: >>But EXISTS is an entirely different animal which is often faster >>... isn't that in the FAQ? There is no reference to EXISTS in the SELECT documentation?? Is this explained somewhere else? -- Keith Gray Technical Services Manager Heart Consulting Services