Received: from localhost (postgresql.org [64.49.215.8])
	by postgresql.org (Postfix) with ESMTP id 4CA5E476496
	for <pgsql-sql@postgresql.org>; Sat, 16 Nov 2002 15:47:18 -0500 (EST)
Received: from joeconway.com (unknown [63.210.180.150])
	by postgresql.org (Postfix) with ESMTP id 7B5854764A9
	for <pgsql-sql@postgresql.org>; Sat, 16 Nov 2002 15:45:48 -0500 (EST)
Received: from [192.168.5.3] (account jconway HELO joeconway.com)
	by joeconway.com (CommuniGate Pro SMTP 3.5.9)
	with ESMTP-TLS id 1431006; Sat, 16 Nov 2002 13:30:06 -0800
Message-ID: <3DD6AE22.4040604@joeconway.com>
Date: Sat, 16 Nov 2002 12:44:18 -0800
From: Joe Conway <mail@joeconway.com>
User-Agent: Mozilla/5.0 (Windows; U; Windows NT 5.0; en-US;
	rv:1.1) Gecko/20020826
X-Accept-Language: en-us, en
MIME-Version: 1.0
To: Josh Berkus <josh@agliodbs.com>
Cc: Evgen Potemkin <evgent@ns.terminal.ru>, pgsql-sql@postgresql.org
Subject: Re: Proposal of hierarchical queries, a la Oracle
References: <web-1829100@davinci.ethosmedia.com>
Content-Type: text/plain; charset=us-ascii; format=flowed
Content-Transfer-Encoding: 7bit
X-Virus-Scanned: by AMaViS new-20020517
X-Archive-Number: 200211/247
X-Sequence-Number: 10389

Josh Berkus wrote:
> Evgren,
> 
> 
>>I want to propose the patch for adding the hierarchical queries
>>posibility.
>>It allows to construct queries a la Oracle for ex:
>>SELECT a,b FROM t CONNECT BY a PRIOR b START WITH cond;
> 
> 
> You'll be thrilled to know that this has already been implemented in
> PostgreSQL 7.3, as a /contrib module, by Joe Conway.
> 
> Download 7.3b5 now if you can't wait; Joe would like more people to
> test his module, anyway.
> 

I have it on my personal TODO to approach this for 7.4, but I'll be happy to 
focus on other things if you'd like to take this on. The connectby() function 
in contrib/tablefunc could be a good starting point for you.

Joe