From: Randolf Richardson, DevNet SysOp 29 <rr@8x.ca>
To: pgsql-sql@postgresql.org
Subject: Re: SOLVED: Emulating 'connect by prior' using stored proc
Date: Wed, 19 Nov 2003 06:56:52 +0000 (UTC)
Message-ID: <Xns9437E76B976E3rr8xca@200.46.204.72> (raw)
References: <B7AD8B4B4A337741B62E633B4827ADD932D5CD@svrexc02.aolau.ops.au.office.aol.com>
[sNip]
> It's the same in this case. The tree building stuff only ever looks down
> so the level returned in the query results will start at 1 no matter
> where you enter your tree. In our case we could enter the tree at
> 'node' 100 and get the tree below that but the function will start at 1
> because we only interested in the data below not the entry point and not
> where in the tree we entered.
Thanks. That's excellent news! =)
> As in the solution if you really want to start it at 5 then set that as
> the value of your second parameter.
Interesting. Although I don't have an immediate need for this, I'm
sure it could be useful when storing the results of multiple queries of this
nature in a temporary table.
--
Randolf Richardson - rr@8x.ca
Inter-Corporate Computer & Network Services, Inc.
Vancouver, British Columbia, Canada
http://www.8x.ca/
This message originated from within a secure, reliable,
high-performance network ... a Novell NetWare network.
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: rr@8x.ca
Subject: Re: SOLVED: Emulating 'connect by prior' using stored proc
In-Reply-To: <Xns9437E76B976E3rr8xca@200.46.204.72>
* 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