Re: recursive SQL - Mailing list pgsql-hackers

From jacob koehler (RRes-Roth)
Subject Re: recursive SQL
Date
Msg-id EFDAAE7F4B83D243868A2F25AD8A4B38D36500@rothe2ksrv1.rothamsted.bbsrc.ac.uk
Whole thread Raw
In response to recursive SQL  ("jacob koehler (RRes-Roth)" <jacob.koehler@bbsrc.ac.uk>)
List pgsql-hackers

> -----Original Message-----
> From: Andrew Overholt [mailto:overholt@redhat.com]
> Sent: 28 June 2004 16:45
> To: jacob koehler (RRes-Roth)
> Cc: pgsql-hackers@postgresql.org; gppl@inbox.ru; Alexander Rüegg
> Subject: Re: recursive SQL
>
>
> * jacob koehler (RRes-Roth) <jacob.koehler@bbsrc.ac.uk>
> [2004-06-27 20:58]:
> >
> > cons:
> > - its not standard SQL (uses oracle style syntax)
>
> Besides the GPL issue, this is my biggest problem.
>
> > i am aware of the fact that tom lane pointed to the fact
> that Andrew
> > Overholt did work towards SQL99 compliant recursive
> queries. it would
> > be interesting to know andrews opinion how much more work would be
> > needed to get a SQL99 compliant version out based on the
> work he has
> > done so far, and what he thinks about Evgen potemkin's
> patch (i cced
> > this mail to Andrew and Evgen).
>
> My work towards SQL-standard recursive queries is nowhere
> near complete and I'm sure any patches I had are severely
> rotten by now.  I'll try to grab what I had and see if I can
> get a patch from which people can maybe pick up.

thank you for your reply. i know that sql99 recursive sql is "a beast". maybe it would be good if you have a look on
evgensrecent work, and try to decide if it is better to continue on his or on your work? or maybe some things from him
andfrom you can be thrown together? 

> Sorry for dropping the ball on this one.  I was back
> finishing up my degree this past year and my current work

which is a reason that i can understand very well...

> isn't database-related :( .  I'll see what I can do.  This
> would be a great feature for PostgreSQL.

i perfectly agree...

cheers
jacob

>
> Andrew
>


pgsql-hackers by date:

Previous
From: Mark Kirkwood
Date:
Subject: Compile Failue on win32 - pipe.c using ereport
Next
From: "Merlin Moncure"
Date:
Subject: Re: Compile Failue on win32 - pipe.c using ereport