From: Andrew - Supernews <andrew+nonews@supernews.com>
To: pgsql-sql@postgresql.org
Subject: Re: Breadth first traversal in PLSQL (How to implement Queue?)
Date: Thu, 16 Dec 2004 03:37:56 -0000
Message-ID: <slrncs20ok.s9e.andrew+nonews@trinity.supernews.net> (raw)
References: <1103136884.9908.22.camel@richard>
On 2004-12-15, Richard Rowell <richard@bowmansystems.com> wrote:
> I have a table with a unary (recursive) relationship that represents a
> hierarchy. With the gracious help of Mike Rylander I was able to port a
> TSQL function that would traverse "up" the hierarchy to PL/SQL. Now I
> need help porting the "down" the hierarchy function.
Have you looked at contrib/tablefunc's connectby() function?
--
Andrew, Supernews
http://www.supernews.com - individual and corporate NNTP services
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: andrew+nonews@supernews.com
Subject: Re: Breadth first traversal in PLSQL (How to implement Queue?)
In-Reply-To: <slrncs20ok.s9e.andrew+nonews@trinity.supernews.net>
* 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