planner & target lists - Mailing list pgsql-hackers

From Hicham G. Elmongui
Subject planner & target lists
Date
Msg-id 200409241322.i8ODMTqS010873@newman.cs.purdue.edu
Whole thread Raw
Responses Re: planner & target lists  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-hackers
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



pgsql-hackers by date:

Previous
From: Greg Stark
Date:
Subject: Re: SQL-Invoked Procedures for 8.1
Next
From: Tom Lane
Date:
Subject: Re: SQL-Invoked Procedures for 8.1