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

Поиск
Список
Период
Сортировка
От Andrew - Supernews
Тема Re: Breadth first traversal in PLSQL (How to implement Queue?)
Дата
Msg-id slrncs20ok.s9e.andrew+nonews@trinity.supernews.net
обсуждение исходный текст
Ответ на Breadth first traversal in PLSQL (How to implement Queue?)  (Richard Rowell <richard@bowmansystems.com>)
Список 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


В списке pgsql-sql по дате отправления:

Предыдущее
От: Mike Rylander
Дата:
Сообщение: Re: Breadth first traversal in PLSQL (How to implement Queue?)
Следующее
От: Roberto Fichera
Дата:
Сообщение: Query aid