Received: from neuman.interaccess.com (neuman.interaccess.com [207.70.126.130]) by hub.org (8.9.3/8.9.3) with ESMTP id OAA03055 for ; Thu, 8 Jul 1999 14:05:08 -0400 (EDT) (envelope-from bruce.lowery@edventions.com) Received: from edventions.com (d233.mvn2.interaccess.com [204.148.83.233]) by neuman.interaccess.com (8.9.0/8.9.0) with ESMTP id NAA29253 for ; Thu, 8 Jul 1999 13:05:06 -0500 (CDT) Sender: bruce@neuman.interaccess.com Message-ID: <37859FE1.D1D95558@edventions.com> Date: Fri, 09 Jul 1999 02:08:18 -0500 From: Bruce Lowery Organization: Edventions X-Mailer: Mozilla 4.51C-Caldera [en] (X11; I; Linux 2.2.5 i686) X-Accept-Language: en MIME-Version: 1.0 To: "pgsql-sql@postgresql.org" Subject: uncorrelated subqueries Content-Type: text/plain; charset=us-ascii Content-Transfer-Encoding: 7bit Hello, In v6.4.2 do uncorrelated subqueries get run on each iteration of the outer loop? For instance, SELECT a FROM table1 WHERE table1.b=XX AND table1.c IN ( SELECT d FROM table2 WHERE table2.e=YY ) ; Does the subquery get run for each row from table 1 where table1.b = XX is true? Bruce Lowery edventions.com