

> -----Original Message-----
> From: Andrew Dunstan [mailto:andrew@dunslane.net] 
> Sent: 26 June 2004 20:42
> To: pgsql-hackers@postgresql.org
> Subject: Re: [HACKERS] recursive SQL
> 
> 
> 
> 
> jacob koehler (RRes-Roth) wrote:
> 
> >hi,
> >
> >i am wondering what you think about including evgen potemkin's patch 
> >for recursive SQL in the next postgres version: 
> >http://gppl.terminal.ru/
> >
> >[snip]
> >
> 
> >- Evgen DID publish this patch under GPL, see: 
> >http://gppl.terminal.ru/README.html
> >
> >  
> >
> 
> It would first have to be relicensed ...

it would be interesting to know if it would be included, IFF the author
publishes it under BSD.

(the authors webpage gives the impression that he is happy to share it.
the fact that the reference to GPL is well hidden in the authors
webpage, indicates that the author did not really think much about which
license he chooses, i.e. he might be happy to change to BSD.)

as i said, i think the lack of recursive queries (whatever syntax they
are in) are one of the major drawbacks of postgres when compared to
other databases.

cheers,
jacob 

Sat, 26 Jun 2004 21:38:35 +0100
"jacob koehler (RRes-Roth)" <jacob.koehler@bbsrc.ac.uk>
Re: recursive SQL
"jacob koehler (RRes-Roth)" <jacob.koehler@bbsrc.ac.uk> writes:
>> It would first have to be relicensed ...

> it would be interesting to know if it would be included, IFF the author
> publishes it under BSD.

This patch has been proposed and rejected before.  It doesn't do the
SQL-standard syntax for recursion, and I have little faith in the
implementation even if it did the right syntax.

There has been some work done towards implementing the spec-compatible
syntax, but it's not likely to get finished in time for 7.5 :-(

			regards, tom lane

Sun, 27 Jun 2004 01:02:09 -0400
Tom Lane <tgl@sss.pgh.pa.us>
Re: recursive SQL 