Re: Hierarchical Queries status?

Hubert FONGARNAND wrote:
> I think it's a recurrent question... but i want to know more about the
> current developpement status of "Hierarchical queries" in postgresql.
>
> Two years ago, this line appeared in the TODO List
> (http://www.postgresql.org/docs/faqs.TODO.html) :
>
> Add SQL:2003 WITH RECURSIVE (hierarchical) queries to SELECT
>
> Most of commercial database support them (SQL Server 2005, DB2, Oracle
> (with Connect By)) and it would be VERY great that at least one "open
> source" database supports this feature.
> We use the CONNECT BY patch made by evgen potemkin
> (http://gppl.moonbone.ru/) this patch works great with the latest 8.1.5
> version but i doubt that it will work with 8.2 (the author doesn't
> answer to mail anymore...). We've try to use the connectby C function
> included in the contrib, but it's up to 10x slower than this patch. I
> know that CONNECT BY is an "oracle invention" but it's the most easier
> way to do hierarchical queries. But we are ready to rewrite our
> application if postgresql would support WITH RECURSIVE.
>
> We don't want to depend on a patch anymore... but now, there's no other
> alternatives... We just want to have more visibility about this "future"
> feature.

We hoped to have this for 8.2, but didn't make it. We are hoping for
8.3.

--
Bruce Momjian bruce(at)momjian(dot)us
EnterpriseDB http://www.enterprisedb.com

+ If your life is a hard drive, Christ can be your backup. +