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!