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

Re: WITH support

From: David Fetter <david(at)fetter(dot)org>
To: Bruce Momjian <bruce(at)momjian(dot)us>
Cc: Edwin Ramirez <edwin(dot)ramirez(at)mssm(dot)edu>, pgsql-hackers(at)postgresql(dot)org
Subject: Re: WITH support
Date: 2006-12-29 12:53:50
Message-ID: (view raw, whole thread or download thread mbox)
Lists: 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? :)

David Fetter <david(at)fetter(dot)org>
phone: +1 415 235 3778        AIM: dfetter666
                              Skype: davidfetter

Remember to vote!

In response to


pgsql-hackers by date

Next:From: Magnus HaganderDate: 2006-12-29 13:35:00
Subject: XML support in MSVC build
Previous:From: Teodor SigaevDate: 2006-12-29 12:51:44
Subject: Re: Bundle of patches

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