Thread

subselects

Bruce Momjian <maillist@candle.pha.pa.us> — 1998-01-21T04:21:22Z

OK, I now have rewrites working with subselects.  At least, I think it
will work.  No way to test it yet.

It basically rewrites all the subqueries first, then the main query.  It
does the lowest queries first.  I do this so if a rewrite adds a
subquery as part of the rewrite, the new subquery does not get
processed.

For each query rewritten, I have code to go into each SubLink and recode
any correlated variables that reference the outer query level I am
rewriting.  Pretty slick.

-- 
Bruce Momjian
maillist@candle.pha.pa.us