Skip site navigation (1) Skip section navigation (2)

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 (view raw or flat)
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

pgsql-hackers by date

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

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group