X-Original-To: pgsql-sql@postgresql.org
Received: from localhost (postgresql.org [64.49.215.8])
	by postgresql.org (Postfix) with ESMTP id EC79E475AFF
	for <pgsql-sql@postgresql.org>; Mon,  3 Mar 2003 13:34:22 -0500 (EST)
Received: from postgresql.org ([64.49.215.8])
	by localhost (postgresql.org [64.49.215.8:10024]) (amavisd-new) with
	SMTP id 77135-03 for <pgsql-sql@postgresql.org>;
	Mon,  3 Mar 2003 13:34:20 -0500 (EST)
Received: from localhost.localdomain (unknown [65.217.53.66])
	by postgresql.org (Postfix) with ESMTP id 0A3A2475ADD
	for <pgsql-sql@postgresql.org>; Mon,  3 Mar 2003 13:34:19 -0500 (EST)
Received: from thorn.mmrd.com (thorn.mmrd.com [172.25.10.100])
	by localhost.localdomain (8.12.5/8.12.5) with ESMTP id h23J446P019937;
	Mon, 3 Mar 2003 14:04:04 -0500
Received: from gnvex001.mmrd.com (gnvex001.mmrd.com [192.168.3.55])
	by thorn.mmrd.com (8.11.6/8.11.6) with ESMTP id h23IYFp23662;
	Mon, 3 Mar 2003 13:34:18 -0500
Received: from camel.mmrd.com ([172.25.5.213]) by gnvex001.mmrd.com with SMTP
	(Microsoft Exchange Internet Mail Service Version 5.5.2653.13)
	id F3HTH659; Mon, 3 Mar 2003 13:34:14 -0500
Subject: Re: Querying Hierarchical Data
From: Robert Treat <xzilla@users.sourceforge.net>
To: Eric <someone@somewhere.com>
Cc: pgsql-sql@postgresql.org
In-Reply-To: <D4z8a.8540$X14.581155@news2.telusplanet.net>
References: <D4z8a.8540$X14.581155@news2.telusplanet.net>
Content-Type: text/plain
Content-Transfer-Encoding: 7bit
X-Mailer: Ximian Evolution 1.0.8 
Date: 03 Mar 2003 13:34:14 -0500
Message-Id: <1046716455.16957.7.camel@camel>
Mime-Version: 1.0
X-Virus-Scanned: by amavisd-new
X-Archive-Number: 200303/86
X-Sequence-Number: 12126

On Sun, 2003-03-02 at 21:27, Eric wrote:
> Hi,
> 
> How do I access hierarchical data under PostgreSQL?
> Does it have SQL command similar to Oracle's CONNECT BY?
> 
> Any help is appreciated
> 
> Eric
> 

Seems like it would be worth mentioning Joe Conway's "tablefunc" module
in contrib, which has a connectby function.

Robert Treat