<div style="text-align: left;">Thanks a lot for your reply. I really appreciate it.<br />I will have only one mark
fieldcreated for the bottommost NewJoin. The other nodes will just use the same mark field. I just want to make sure
thatflag propagate up the pipeline.<br /></div>Thanks again,<br />ehab<br /><br /><br /><hr id="stopSpelling" />>
To:ehabgalal123@hotmail.com<br />> CC: pgsql-sql@postgresql.org<br />> Subject: Re: marking tuples<br />>
From:stark@enterprisedb.com<br />> Date: Wed, 5 Dec 2007 08:44:15 +0000<br />> <br />> "Ehab Galal"
<ehabgalal123@hotmail.com>writes:<br />> <br />> > In my algorithm, each NewJoin node may "mark" its
ps_ResultTupleSlotwith<br />> > either red/green. I need that mark to flow in the pipeline so that i can<br
/>>> collect them at the top aggregate.<br />> <br />> How will you tell about the marks from different
NewJoins?<br/>> <br />> I think you'll have to "project" the tuple and add a resjunk column to<br />> indicate
thatflag. I don't know how you'll identify that column from other<br />> such flag columns other NewJoin nodes have
added.<br/>> <br />> You could look at the setop code in prepunion.c like intersection to see other<br />>
planswhich add flag columns. In those cases though they are used by the<br />> direct parent of the node which added
it,so the planner can just mark a field<br />> in the parent indicating which column it should look at for the
flag.<br/>> <br />> -- <br />> Gregory Stark<br />> EnterpriseDB http://www.enterprisedb.com<br />> Ask
meabout EnterpriseDB's On-Demand Production Tuning<br /><br /><hr />Connect and share in new ways with Windows Live. <a
href="http://www.windowslive.com/connect.html?ocid=TXT_TAGLM_Wave2_newways_112007"target="_new">Connect now!</a>