X-Original-To: pgsql-sql@postgresql.org
Received: from localhost (postgresql.org [64.49.215.8])
	by postgresql.org (Postfix) with ESMTP id 3743547595A
	for <pgsql-sql@postgresql.org>; Mon,  3 Mar 2003 13:27:41 -0500 (EST)
Received: from postgresql.org ([64.49.215.8])
	by localhost (postgresql.org [64.49.215.8:10024]) (amavisd-new) with
	SMTP id 75373-02 for <pgsql-sql@postgresql.org>;
	Mon,  3 Mar 2003 13:27:35 -0500 (EST)
Received: from joeconway.com (63-210-180-150.skyriver.net [63.210.180.150])
	by postgresql.org (Postfix) with ESMTP id 9C7C447590C
	for <pgsql-sql@postgresql.org>; Mon,  3 Mar 2003 13:27:35 -0500 (EST)
Received: from [206.19.64.3] (account jconway HELO joeconway.com)
	by joeconway.com (CommuniGate Pro SMTP 4.0.4)
	with ESMTP-TLS id 1626657; Mon, 03 Mar 2003 11:03:14 -0800
Message-ID: <3E639E16.500@joeconway.com>
Date: Mon, 03 Mar 2003 10:25:26 -0800
From: Joe Conway <mail@joeconway.com>
User-Agent: Mozilla/5.0 (Windows; U; Windows NT 5.0; en-US;
	rv:1.2.1) Gecko/20021130
X-Accept-Language: en-us, en
MIME-Version: 1.0
To: Eric <someone@somewhere.com>
Cc: pgsql-sql@postgresql.org
Subject: Re: Querying Hierarchical Data
References: <D4z8a.8540$X14.581155@news2.telusplanet.net>
In-Reply-To: <D4z8a.8540$X14.581155@news2.telusplanet.net>
Content-Type: text/plain; charset=us-ascii; format=flowed
Content-Transfer-Encoding: 7bit
X-Virus-Scanned: by amavisd-new
X-Archive-Number: 200303/84
X-Sequence-Number: 12124

Eric wrote:
> How do I access hierarchical data under PostgreSQL?
> Does it have SQL command similar to Oracle's CONNECT BY?
> 

In addition to all the other good suggestions, if you are using Postgres 
version 7.3.x, take a look at contrib/tablefunc for a function called 
connectby().

HTH,

Joe