Re: about the pstate node - Mailing list pgsql-general

From Tom Lane
Subject Re: about the pstate node
Date
Msg-id 26993.1064084951@sss.pgh.pa.us
Whole thread Raw
In response to about the pstate node  (博\xD7X 翟 <powerzbx@yahoo.com.cn>)
List pgsql-general
=?gb2312?q?=B2=A9=D7X=20=B5=D4?= <powerzbx@yahoo.com.cn> writes:
>          I am trying to analyse the source code  in " /backend/paser". And I am really puzzled about the node
"PaserState",especiallythe meaning of p_namespace and p_joinlist!  

p_namespace is a list of the FROM items (RangeTblRef's or JoinExpr's)
whose fields can validly be referenced from the current point in the
query.  We alter it while scanning the ON clause of a JOIN, for example,
because the ON clause is only allowed to refer to fields from the JOIN's
input tables.  p_joinlist has the same structure but is a list of all
the FROM items that the planner must join to execute the query.

Usually the final states of p_namespace and p_joinlist are the same, but
there are special cases where items get entered into only one list or the
other (mostly for NEW and OLD in rules, IIRC).

            regards, tom lane

pgsql-general by date:

Previous
From: Ron Johnson
Date:
Subject: Re: need for in-place upgrades
Next
From: Mike Mascari
Date:
Subject: Re: PG + PHP, was Re: Zend survey result about dbms...