uncorrelated subqueries - Mailing list 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