From: Joe Conway <mail@joeconway.com>
To: Josh Berkus <josh@agliodbs.com>
Cc: Evgen Potemkin <evgent@ns.terminal.ru>
Cc: pgsql-sql@postgresql.org
Subject: Re: Proposal of hierarchical queries, a la Oracle
Date: Sat, 16 Nov 2002 12:44:18 -0800
Message-ID: <3DD6AE22.4040604@joeconway.com> (raw)
References: <web-1829100@davinci.ethosmedia.com>
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
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-sql@postgresql.org
Cc: mail@joeconway.com, josh@agliodbs.com, evgent@ns.terminal.ru
Subject: Re: Proposal of hierarchical queries, a la Oracle
In-Reply-To: <3DD6AE22.4040604@joeconway.com>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox