Re: WITH support

David Fetter wrote:
> On Thu, Dec 28, 2006 at 10:52:45PM -0500, Bruce Momjian wrote:
> > Edwin Ramirez wrote:
> > > Hello,
> > >
> > > What is the status of supporting the "WITH" keyword?
> >
> > I see these TODO items:
> >
> > * Add SQL99 WITH clause to SELECT
> > * Add SQL:2003 WITH RECURSIVE (hierarchical) queries to SELECT
> >
> > Are they the same item?
>
> Not exactly. There is a WITH in the SQL:2003 spec (T121 and T122)
> which doesn't include RECURSIVE, but they're related to the RECURSIVE
> one (T131).
>
> > Someone has said they will do RECURSIVE for 8.3, but there is no
> > guarantee.
>
> Is there code for this yet? Who's the someone? :)

No code yet, and I don't remember who said they were working on it.

--
Bruce Momjian bruce(at)momjian(dot)us
EnterpriseDB http://www.enterprisedb.com

+ If your life is a hard drive, Christ can be your backup. +