Re: SQL99 hierarchical queries stalled

On Tue, May 17, 2005 at 11:24:19PM +0300, Hannu Krosing wrote:
> On T, 2005-05-17 at 11:22 -0400, Tom Lane wrote:
> > Hannu Krosing <hannu(at)skype(dot)net> writes:
> > > On T, 2005-05-17 at 00:42 -0400, Tom Lane wrote:
> > >> I seem to recall some discussion of how to do this in the past;
> > >> have you trolled the pghackers archives?
> >
> > > I think that Jasons inspiration for doing it came from the the fact that
> > > there are already now abandoned patches for doing it.
> >
> > Having looked over the latest patch, my advice would be to ignore it :-(
> > It's almost completely devoid of documentation, except for comments
> > that he copied-and-pasted from elsewhere without modification. Wrong
> > comments are even worse than none.
>
> ANd even worse - this is from the README on the website:
>
> ----8<---------8<---------8<---------8<---------8<---------8<---------8<-----
> WHAT'S THIS
>
> This is a patch which allows PgSQL to make hierarchical queries a la
> Oracle do.
>
> (c) Evgen Potemkin 2003,2004, < gppl at inbox dot ru >, entirely based
> on PostgreSQL (http://www.postgresql.org)
> Patch itself distributed under GPL. No warranty of any kind is given,
> use it at your own risk.

It's the notes on the CONNECT BY patch, not the WITH patch. The WITH
patch, as far as I can tell, is in the public domain.

Cheers,
D
--
David Fetter david(at)fetter(dot)org http://fetter.org/
phone: +1 510 893 6100 mobile: +1 415 235 3778

Remember to vote!