Hi,
I am confused about an internal point of the planner.
Consider a select query and the output target list at the root of the tree.
This target lists points to some Vars. Each of which has as relation either
INNER/OUTER.
Does this INNER/OUTER refer to the inner/outer relations of the top-most
node in the tree or to the bottom-most one.
In other words, in the following tree, a variable in B that shows in Op1's
target list, does it have its relation as INNER (which is B) or OUTER (which
is Op2)
Op1 / \ / \ / \ Op2 Op3 / \ / \ / \ / \ A B C D
Regards,
--h