| 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: | 20061229125350.GA3332@fetter.org |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| 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? :)
Cheers,
D
--
David Fetter <david(at)fetter(dot)org> http://fetter.org/
phone: +1 415 235 3778 AIM: dfetter666
Skype: davidfetter
Remember to vote!
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Magnus Hagander | 2006-12-29 13:35:00 | XML support in MSVC build |
| Previous Message | Teodor Sigaev | 2006-12-29 12:51:44 | Re: Bundle of patches |