Re: Breadth first traversal in PLSQL (How to implement Queue?)

From: Andrew - Supernews <andrew+nonews(at)supernews(dot)com>
To: pgsql-sql(at)postgresql(dot)org
Subject: Re: Breadth first traversal in PLSQL (How to implement Queue?)
Date: 2004-12-16 03:37:56
Message-ID: slrncs20ok.s9e.andrew+nonews@trinity.supernews.net
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-sql

On 2004-12-15, Richard Rowell <richard(at)bowmansystems(dot)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

In response to

Browse pgsql-sql by date

  From Date Subject
Next Message Roberto Fichera 2004-12-16 10:34:33 Query aid
Previous Message Mike Rylander 2004-12-16 03:23:56 Re: Breadth first traversal in PLSQL (How to implement Queue?)