Re: WITH support - Mailing list pgsql-hackers

From David Fetter
Subject Re: WITH support
Date
Msg-id 20070103232333.GI28334@fetter.org
Whole thread Raw
In response to Re: WITH support  ("Jonah H. Harris" <jonah.harris@gmail.com>)
Responses Re: WITH support  ("Jonah H. Harris" <jonah.harris@gmail.com>)
List pgsql-hackers
On Wed, Jan 03, 2007 at 04:19:19PM -0700, Jonah H. Harris wrote:
> On 1/3/07, Hubert FONGARNAND <informatique.internet@fiducial.fr> wrote:
> >Why not looking at http://gppl.moonbone.ru/ evgen potemkin. has
> >ever made a patch for WITH and CONNECT BY?
> 
> Nope, no good.  This is what I started with last time and the
> refactoring attempt at WITH is just too massive.  As for CONNECT BY,
> PostgreSQL does not want the syntax, they want ANSI/ISO WITH
> [RECURSIVE]... so even starting there isn't great.
> 
> This is really something that needs to be decided on before
> implementation... or it will probably never get in.

As I recall, it was decided long ago, and the conclusions were:

* Only BSD-compatibly licensed code goes in PostgreSQL's code base,

and

* PostgreSQL will only support the SQL:2003 standard WITH (RECURSIVE) syntax in the main line code.

Cheers,
D
-- 
David Fetter <david@fetter.org> http://fetter.org/
phone: +1 415 235 3778        AIM: dfetter666                             Skype: davidfetter

Remember to vote!


pgsql-hackers by date:

Previous
From: "Jonah H. Harris"
Date:
Subject: Re: WITH support
Next
From: "Jonah H. Harris"
Date:
Subject: Re: WITH support