Re: WITH support - Mailing list pgsql-hackers

From David Fetter
Subject Re: WITH support
Date
Msg-id 20061229125350.GA3332@fetter.org
Whole thread Raw
In response to Re: WITH support  (Bruce Momjian <bruce@momjian.us>)
Responses Re: WITH support  (Bruce Momjian <bruce@momjian.us>)
List pgsql-hackers
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? :)

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: Teodor Sigaev
Date:
Subject: Re: [PATCHES] Bundle of patches
Next
From: Stephen Frost
Date:
Subject: Re: TODO: GNU TLS