From: Ehab Galal <ehabgalal123@hotmail.com>
To: Gregory Stark <stark@enterprisedb.com>
Cc: pgsql-sql@postgresql.org
Subject: Re: marking tuples
Date: Wed, 5 Dec 2007 08:34:34 -0500
Message-ID: <BAY138-W30EFA9996F6FC96AF44C95966E0@phx.gbl> (raw)
In-Reply-To: <87odd55y5c.fsf@oxford.xeocode.com>
References: <BAY138-W31C72CF9118BE1CB6BC00966D0@phx.gbl>
<87odd55y5c.fsf@oxford.xeocode.com>
Thanks a lot for your reply. I really appreciate it.
I will have only one mark field created for the bottommost NewJoin. The other nodes will just use the same mark field. I just want to make sure that flag propagate up the pipeline.
Thanks again,
ehab
> To: ehabgalal123@hotmail.com
> CC: pgsql-sql@postgresql.org
> Subject: Re: marking tuples
> From: stark@enterprisedb.com
> Date: Wed, 5 Dec 2007 08:44:15 +0000
>
> "Ehab Galal" <ehabgalal123@hotmail.com> writes:
>
> > In my algorithm, each NewJoin node may "mark" its ps_ResultTupleSlot with
> > either red/green. I need that mark to flow in the pipeline so that i can
> > collect them at the top aggregate.
>
> How will you tell about the marks from different NewJoins?
>
> I think you'll have to "project" the tuple and add a resjunk column to
> indicate that flag. I don't know how you'll identify that column from other
> such flag columns other NewJoin nodes have added.
>
> You could look at the setop code in prepunion.c like intersection to see other
> plans which add flag columns. In those cases though they are used by the
> direct parent of the node which added it, so the planner can just mark a field
> in the parent indicating which column it should look at for the flag.
>
> --
> Gregory Stark
> EnterpriseDB http://www.enterprisedb.com
> Ask me about EnterpriseDB's On-Demand Production Tuning
_________________________________________________________________
Connect and share in new ways with Windows Live.
http://www.windowslive.com/connect.html?ocid=TXT_TAGLM_Wave2_newways_112007=
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-sql@postgresql.org
Cc: ehabgalal123@hotmail.com, stark@enterprisedb.com
Subject: Re: marking tuples
In-Reply-To: <BAY138-W30EFA9996F6FC96AF44C95966E0@phx.gbl>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox