Re: [GENERAL] pull_up_subqueries question

2004-01-02 Thread Tom Lane
Dennis Haney <[EMAIL PROTECTED]> writes: > I was looking at pull_up_subqueries > (backend/optimizer/prep/prepjointree.c 135) and I was wondering why the > recursive optimization is only done on subqueries that can be optimized. Because it will be done when the subquery is planned (via recursion

[GENERAL] pull_up_subqueries question

2004-01-02 Thread Dennis Haney
Hi I was looking at pull_up_subqueries (backend/optimizer/prep/prepjointree.c 135) and I was wondering why the recursive optimization is only done on subqueries that can be optimized. As in, why isn't the code like: if (rte->rtekind == RTE_SUBQUERY) { subquery = copyObject(subquery);