X-Original-To: pgsql-sql-postgresql.org@localhost.postgresql.org Received: from localhost (unknown [200.46.204.144]) by svr1.postgresql.org (Postfix) with ESMTP id A53DB3B5E01 for ; Thu, 16 Dec 2004 03:38:11 +0000 (GMT) Received: from svr1.postgresql.org ([200.46.204.71]) by localhost (av.hub.org [200.46.204.144]) (amavisd-new, port 10024) with ESMTP id 53803-09 for ; Thu, 16 Dec 2004 03:38:05 +0000 (GMT) Received: from floppy.pyrenet.fr (floppy.pyrenet.fr [194.250.190.2]) by svr1.postgresql.org (Postfix) with ESMTP id 8DC8A3B5E10 for ; Thu, 16 Dec 2004 03:38:08 +0000 (GMT) Received: by floppy.pyrenet.fr (Postfix, from userid 106) id C57353195C; Thu, 16 Dec 2004 04:38:08 +0100 (MET) From: Andrew - Supernews X-Newsgroups: pgsql.sql Subject: Re: Breadth first traversal in PLSQL (How to implement Queue?) Date: Thu, 16 Dec 2004 03:37:56 -0000 Organization: http://www.supernews.com - all your nntp are belong to us Message-ID: References: <1103136884.9908.22.camel@richard> Reply-To: andrew@supernews.com User-Agent: slrn/0.9.8.0 (FreeBSD) X-Complaints-To: abuse@supernews.com Lines: 11 To: pgsql-sql@postgresql.org X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, hits=0.01 tagged_above=0 required=5 tests=AWL X-Spam-Level: X-Archive-Number: 200412/99 X-Sequence-Number: 19719 On 2004-12-15, Richard Rowell 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