Received: from localhost (unknown [200.46.204.182])
	by postgresql.org (Postfix) with ESMTP id C38E32E00CC
	for <pgsql-sql-postgresql.org@postgresql.org>;
	Tue,  4 Dec 2007 18:25:18 -0400 (AST)
Received: from postgresql.org ([200.46.204.71])
	by localhost (mx1.hub.org [200.46.204.182]) (amavisd-maia, port 10024)
	with ESMTP id 87043-05 for <pgsql-sql-postgresql.org@postgresql.org>;
	Tue,  4 Dec 2007 18:25:06 -0400 (AST)
Received: from bay0-omc2-s16.bay0.hotmail.com (bay0-omc2-s16.bay0.hotmail.com
	[65.54.246.152])
	by postgresql.org (Postfix) with ESMTP id 077A82E011F
	for <pgsql-sql@postgresql.org>; Tue,  4 Dec 2007 18:25:09 -0400 (AST)
Received: from BAY138-W3 ([64.4.49.38]) by bay0-omc2-s16.bay0.hotmail.com with
	Microsoft SMTPSVC(6.0.3790.3959); Tue, 4 Dec 2007 14:25:09 -0800
Message-ID: <BAY138-W31C72CF9118BE1CB6BC00966D0@phx.gbl>
Content-Type: multipart/alternative;
	boundary="_7d956ece-9523-4f92-bf1e-4cd7e7aedd25_"
X-Originating-IP: [128.10.9.112]
From: Ehab Galal <ehabgalal123@hotmail.com>
To: "pgsql-sql@postgresql.org" <pgsql-sql@postgresql.org>
Subject: marking tuples
Date: Tue, 4 Dec 2007 17:25:09 -0500
Importance: Normal
MIME-Version: 1.0
X-OriginalArrivalTime: 04 Dec 2007 22:25:09.0229 (UTC)
	FILETIME=[8758C1D0:01C836C4]
X-Virus-Scanned: Maia Mailguard 1.0.1
X-Archive-Number: 200712/8
X-Sequence-Number: 29700

--_7d956ece-9523-4f92-bf1e-4cd7e7aedd25_
Content-Type: text/plain; charset="Windows-1252"
Content-Transfer-Encoding: quoted-printable

Hi,
I am implementing a new algorithm inside postgresql for a side research pro=
ject. I am just wondering if anyone may give me few hints about the followi=
ng problem:

Consider the following plan:

NewAggregate
    ->NewJoin
          ->NewJoin
                ->NewJoin
                       ->SeqScan
=0A=
                       ->SeqScan
                ->SeqScan
          ->SeqScan


In my algorithm,=20
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.

Any hints about how to keep such mark is greatly appreciated.

Thanks a lot,
Ehab

_________________________________________________________________
You keep typing, we keep giving. Download Messenger and join the i=92m Init=
iative now.
http://im.live.com/messenger/im/home/?source=3DTAGLM=

--_7d956ece-9523-4f92-bf1e-4cd7e7aedd25_
Content-Type: text/html; charset="Windows-1252"
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;">Hi,<br>I am impl=
ementing a new algorithm inside postgresql for a side research project. I a=
m just wondering if anyone may give me few hints about the following proble=
m:<br><br>Consider the following plan:<br><br>NewAggregate<br>&nbsp;&nbsp;&=
nbsp; -&gt;NewJoin<br>&nbsp; &nbsp;&nbsp; &nbsp;&nbsp;&nbsp;&nbsp; -&gt;New=
Join<br>&nbsp;&nbsp;&nbsp; &nbsp; &nbsp;&nbsp; &nbsp;&nbsp; &nbsp;&nbsp;&nb=
sp; -&gt;NewJoin<br>&nbsp;&nbsp;&nbsp; &nbsp;&nbsp; &nbsp;&nbsp; &nbsp; &nb=
sp; &nbsp; &nbsp;&nbsp;&nbsp; &nbsp;&nbsp; -&gt;SeqScan<br>=0A=
&nbsp;&nbsp;&nbsp; &nbsp;&nbsp; &nbsp;&nbsp; &nbsp; &nbsp;&nbsp; &nbsp; &nb=
sp; &nbsp; &nbsp; -&gt;SeqScan<br>&nbsp; &nbsp; &nbsp; &nbsp;&nbsp; &nbsp;&=
nbsp; &nbsp;&nbsp;&nbsp; -&gt;SeqScan<br>&nbsp; &nbsp; &nbsp;&nbsp; &nbsp;&=
nbsp; -&gt;SeqScan<br><br><br>In my algorithm, <br>each NewJoin node may "m=
ark" 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.<br><br>An=
y hints about how to keep such mark is greatly appreciated.<br><br>Thanks a=
 lot,<br>Ehab<br></div><br /><hr />You keep typing, we keep giving. Downloa=
d Messenger and join the i=92m Initiative now. <a href=3D'http://im.live.co=
m/messenger/im/home/?source=3DCRM_WL_joinnow' target=3D'_new'>Join in!</a><=
/body>
</html>=

--_7d956ece-9523-4f92-bf1e-4cd7e7aedd25_--