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 AE65552971 for ; Fri, 1 Jul 2005 14:44:55 -0300 (ADT) 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 56300-08 for ; Fri, 1 Jul 2005 17:44:49 +0000 (GMT) Received: from smtp.nildram.co.uk (smtp.nildram.co.uk [195.112.4.54]) by svr1.postgresql.org (Postfix) with ESMTP id 1146752934 for ; Fri, 1 Jul 2005 14:44:48 -0300 (ADT) Received: from HYDROGEN (unknown [62.3.216.34]) by smtp.nildram.co.uk (Postfix) with ESMTP id 0F956253974; Fri, 1 Jul 2005 18:44:45 +0100 (BST) From: "Nick Stone" To: Cc: Subject: Re: Some help please Date: Fri, 1 Jul 2005 18:42:45 +0100 MIME-Version: 1.0 Content-Type: text/plain; charset="us-ascii" Content-Transfer-Encoding: 7bit X-Mailer: Microsoft Office Outlook, Build 11.0.6353 Thread-Index: AcV+YkPXATRs/AFDTQqxcHYT/TnhMwAAfxoA In-Reply-To: <200507011030.03397.josh@agliodbs.com> X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2900.2180 Message-Id: <20050701174445.0F956253974@smtp.nildram.co.uk> X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, hits=0 tagged_above=0 required=5 tests= X-Spam-Level: X-Archive-Number: 200507/8 X-Sequence-Number: 21986 That's great - thanks very much Nick -----Original Message----- From: Josh Berkus [mailto:josh@agliodbs.com] Sent: 01 July 2005 18:30 To: Nick Stone Cc: pgsql-sql@postgresql.org Subject: Re: [SQL] Some help please Nick, > I'm interested in using the connectby() function which I gather from > the lists can be used in a similar way to the Oracle connect by ... > PRIOR functionality. Does anybody know where there's an example of > this in use or better still could somebody post an example. Examples are in the /contrib directory where the connectby source is: /contrib/tablefunc/README.tablefunc -- --Josh Josh Berkus Aglio Database Solutions San Francisco