Re: recursive SQL

From: "jacob koehler (RRes-Roth)" <jacob(dot)koehler(at)bbsrc(dot)ac(dot)uk>
To: "Andrew Overholt" <overholt(at)redhat(dot)com>
Cc: <pgsql-hackers(at)postgresql(dot)org>, <gppl(at)inbox(dot)ru>, Alexander Rüegg <arueegg(at)uni-bielefeld(dot)de>
Subject: Re: recursive SQL
Date: 2004-06-30 10:40:17
Message-ID: EFDAAE7F4B83D243868A2F25AD8A4B38D36500@rothe2ksrv1.rothamsted.bbsrc.ac.uk
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

> -----Original Message-----
> From: Andrew Overholt [mailto:overholt(at)redhat(dot)com]
> Sent: 28 June 2004 16:45
> To: jacob koehler (RRes-Roth)
> Cc: pgsql-hackers(at)postgresql(dot)org; gppl(at)inbox(dot)ru; Alexander Rüegg
> Subject: Re: recursive SQL
>
>
> * jacob koehler (RRes-Roth) <jacob(dot)koehler(at)bbsrc(dot)ac(dot)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 evgens recent work, and try to decide if it is better to continue on his or on your work? or maybe some things from him and from 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
>

Browse pgsql-hackers by date

  From Date Subject
Next Message Merlin Moncure 2004-06-30 13:11:59 Re: Compile Failue on win32 - pipe.c using ereport
Previous Message Dave Page 2004-06-30 09:44:35 ODBC Developers