uncorrelated subqueries

From: Bruce Lowery <bruce(dot)lowery(at)edventions(dot)com>
To: "pgsql-sql(at)postgresql(dot)org" <pgsql-sql(at)postgresql(dot)org>
Subject: uncorrelated subqueries
Date: 1999-07-09 07:08:18
Message-ID: 37859FE1.D1D95558@edventions.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-sql

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

Browse pgsql-sql by date

  From Date Subject
Next Message Roland_DUBOULOZ 1999-07-09 09:25:13 Bad date representation
Previous Message Stephen Boyle 1999-07-09 05:53:06 Re: [SQL] offtopic: odbc C frontend for linux?