Received: from localhost (unknown [200.46.204.183])
	by postgresql.org (Postfix) with ESMTP id B45AB2E00ED
	for <pgsql-sql-postgresql.org@postgresql.org>;
	Wed,  5 Dec 2007 09:34:40 -0400 (AST)
Received: from postgresql.org ([200.46.204.71])
	by localhost (mx1.hub.org [200.46.204.183]) (amavisd-maia, port 10024)
	with ESMTP id 57522-04 for <pgsql-sql-postgresql.org@postgresql.org>;
	Wed,  5 Dec 2007 09:34:36 -0400 (AST)
Received: from bay0-omc1-s14.bay0.hotmail.com (bay0-omc1-s14.bay0.hotmail.com
	[65.54.246.86]) by postgresql.org (Postfix) with ESMTP id 4B4322E0117
	for <pgsql-sql@postgresql.org>; Wed,  5 Dec 2007 09:34:36 -0400 (AST)
Received: from BAY138-W30 ([64.4.49.65]) by bay0-omc1-s14.bay0.hotmail.com
	with Microsoft SMTPSVC(6.0.3790.3959);
	Wed, 5 Dec 2007 05:34:34 -0800
Message-ID: <BAY138-W30EFA9996F6FC96AF44C95966E0@phx.gbl>
Content-Type: multipart/alternative;
	boundary="_5f4fd896-d570-4012-9848-f18675350974_"
X-Originating-IP: [128.10.9.112]
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
Importance: Normal
In-Reply-To: <87odd55y5c.fsf@oxford.xeocode.com>
References: <BAY138-W31C72CF9118BE1CB6BC00966D0@phx.gbl>
	<87odd55y5c.fsf@oxford.xeocode.com>
MIME-Version: 1.0
X-OriginalArrivalTime: 05 Dec 2007 13:34:34.0782 (UTC)
	FILETIME=[92F363E0:01C83743]
X-Virus-Scanned: Maia Mailguard 1.0.1
X-Archive-Number: 200712/13
X-Sequence-Number: 29705

--_5f4fd896-d570-4012-9848-f18675350974_
Content-Type: text/plain; charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable

Thanks a lot for your reply. I really appreciate it.
I will have only one mark field created for the bottommost NewJoin. The oth=
er nodes will just use the same mark field. I just want to make sure that f=
lag 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
>=20
> "Ehab Galal" <ehabgalal123@hotmail.com> writes:
>=20
> > In my algorithm, each NewJoin node may "mark" its ps_ResultTupleSlot wi=
th
> > either red/green. I need that mark to flow in the pipeline so that i ca=
n
> > collect them at the top aggregate.
>=20
> How will you tell about the marks from different NewJoins?
>=20
> 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 oth=
er
> such flag columns other NewJoin nodes have added.
>=20
> 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.
>=20
> --=20
>   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=3DTXT_TAGLM_Wave2_newways_1120=
07=

--_5f4fd896-d570-4012-9848-f18675350974_
Content-Type: text/html; charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable

<html>
<head>
<style>
.hmmessage P
{
margin:0px;
padding:0px
}
body.hmmessage
{
FONT-SIZE: 10pt;
FONT-FAMILY:Tahoma
}
</style>
</head>
<body class=3D'hmmessage'><div style=3D"text-align: left;">Thanks a lot for=
 your reply. I really appreciate it.<br>I will have only one mark field cre=
ated for the bottommost NewJoin. The other nodes will just use the same mar=
k field. I just want to make sure that flag propagate up the pipeline.<br><=
/div>Thanks again,<br>ehab<br><br><br><hr id=3D"stopSpelling">&gt; To: ehab=
galal123@hotmail.com<br>&gt; CC: pgsql-sql@postgresql.org<br>&gt; Subject: =
Re: marking tuples<br>&gt; From: stark@enterprisedb.com<br>&gt; Date: Wed, =
5 Dec 2007 08:44:15 +0000<br>&gt; <br>&gt; "Ehab Galal" &lt;ehabgalal123@ho=
tmail.com&gt; writes:<br>&gt; <br>&gt; &gt; In my algorithm, each NewJoin n=
ode may "mark" its ps_ResultTupleSlot with<br>&gt; &gt; either red/green. I=
 need that mark to flow in the pipeline so that i can<br>&gt; &gt; collect =
them at the top aggregate.<br>&gt; <br>&gt; How will you tell about the mar=
ks from different NewJoins?<br>&gt; <br>&gt; I think you'll have to "projec=
t" the tuple and add a resjunk column to<br>&gt; indicate that flag. I don'=
t know how you'll identify that column from other<br>&gt; such flag columns=
 other NewJoin nodes have added.<br>&gt; <br>&gt; You could look at the set=
op code in prepunion.c like intersection to see other<br>&gt; plans which a=
dd flag columns. In those cases though they are used by the<br>&gt; direct =
parent of the node which added it, so the planner can just mark a field<br>=
&gt; in the parent indicating which column it should look at for the flag.<=
br>&gt; <br>&gt; -- <br>&gt;   Gregory Stark<br>&gt;   EnterpriseDB        =
  http://www.enterprisedb.com<br>&gt;   Ask me about EnterpriseDB's On-Dema=
nd Production Tuning<br><br /><hr />Connect and share in new ways with Wind=
ows Live. <a href=3D'http://www.windowslive.com/connect.html?ocid=3DTXT_TAG=
LM_Wave2_newways_112007' target=3D'_new'>Connect now!</a></body>
</html>=

--_5f4fd896-d570-4012-9848-f18675350974_--