Received: from lh00.opsion.fr (lh00.opsion.fr [212.73.208.226]) by postgresql.org (8.11.3/8.11.4) with SMTP id f941J5n60093 for ; Wed, 3 Oct 2001 21:19:05 -0400 (EDT) (envelope-from cnliou@eurosport.com) Received: from 10.1.1.8 [10.1.1.8] by lh00.opsion.fr; Thu, 4 Oct 2001 01:18:53 GMT Send-By: 203.66.130.112 with Mozilla/4.78 [en] (Win95; U) To: Subject: EXISTS Keyword From: MIME-Version: 1.0 Content-Type: text/plain; charset="iso-8859-1" Date: Thu, 4 Oct 2001 01:18:53 GMT Message-id: <200110040118.3520@lh00.opsion.fr> Content-Transfer-Encoding: 8bit X-MIME-Autoconverted: from quoted-printable to 8bit by postgresql.org id f941J6n60095 X-Archive-Number: 200110/41 X-Sequence-Number: 4996 Hello! I vaguely remember that someone said somewhere that EXISTS runs faster than IN: SELECT * FROM table1 where field1 EXISTS (SELECT field4 FROM table2) However, all I got from version 7.1.3 is: ERROR: parser: parse error at or near "exists" While below works: SELECT * FROM table1 where field1 IN (SELECT field4 FROM table2) Any key points I have missed? CN -------------------------------------------------------- You too can have your own email address from Eurosport. http://www.eurosport.com