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

Tue, 20 Jan 1998 23:21:22 -0500 (EST)
Bruce Momjian <maillist@candle.pha.pa.us>
subselects