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@momjian.us EnterpriseDB    http://www.enterprisedb.com
 + If your life is a hard drive, Christ can be your backup. +