Re: Recursive queries? - Mailing list pgsql-hackers

From Robert Treat
Subject Re: Recursive queries?
Date
Msg-id 1075906544.26805.20.camel@camel
Whole thread Raw
In response to Re: Recursive queries?  (Hans-Jürgen Schönig <postgres@cybertec.at>)
Responses Re: Recursive queries?  (Hannu Krosing <hannu@tm.ee>)
List pgsql-hackers
On Wed, 2004-02-04 at 05:28, Hans-Jürgen Schönig wrote:
> Christopher Kings-Lynne wrote:
> >> There is a website somewhere where a guy posts his patch he is
> >> maintaining that does it.  I'll try to find it...
> >
> >
> > Found it.  Check it out:
> >
> > http://gppl.terminal.ru/index.eng.html
> >
> > Patch is current for 7.4, Oracle syntax.
> >
> > Chris
>
>
> I had a look at the patch.
> It is still in development but it seems to work nicely - at least I have
> been able to get the same results with Oracle.
>
> I will try it with a lot of data this afternoon so that we can compare
> Oracle vs. Pg performance. I expect horrible results ;).
>
> Does this patch have a serious chance to make it into Pg some day?
> I think Oracle's syntax is not perfect but is easy to handle and many
> people are used to it. In people's mind recursive queries = CONNECT BY
> and many people (like me) miss it sadly.
>
> If this patch has a serious chance I'd like to do some investigation and
> some real-world data testing.
>

Seems it has no chance of getting in as it is GPL'd code... so step one
would be convincing him to relicense it.

As a side note, I thought Joe Conway also had an implementation of
this...

Robert Treat
--
Build A Brighter Lamp :: Linux Apache {middleware} PostgreSQL



pgsql-hackers by date:

Previous
From: "Marc G. Fournier"
Date:
Subject: Re: PITR Dead horse?
Next
From: Tom Lane
Date:
Subject: Re: Recursive queries?