Re: WITH support

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!