Re: WITH support

From: David Fetter <david(at)fetter(dot)org>
To: "Jonah H(dot) Harris" <jonah(dot)harris(at)gmail(dot)com>
Cc: Hubert FONGARNAND <informatique(dot)internet(at)fiducial(dot)fr>, Mark Cave-Ayland <mark(dot)cave-ayland(at)ilande(dot)co(dot)uk>, Bruce Momjian <bruce(at)momjian(dot)us>, Edwin Ramirez <edwin(dot)ramirez(at)mssm(dot)edu>, pgsql-hackers(at)postgresql(dot)org
Subject: Re: WITH support
Date: 2007-01-03 23:23:33
Message-ID: 20070103232333.GI28334@fetter.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

On Wed, Jan 03, 2007 at 04:19:19PM -0700, Jonah H. Harris wrote:
> On 1/3/07, Hubert FONGARNAND <informatique(dot)internet(at)fiducial(dot)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(at)fetter(dot)org> http://fetter.org/
phone: +1 415 235 3778 AIM: dfetter666
Skype: davidfetter

Remember to vote!

In response to

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Jonah H. Harris 2007-01-03 23:24:57 Re: WITH support
Previous Message Jonah H. Harris 2007-01-03 23:21:54 Re: WITH support