Re: Breadth first traversal in PLSQL (How to implement Queue?) - Mailing list pgsql-sql

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