Re: recursive SQL and with clause

I was just wondering when we could reasonably expect recursive SQL to be
added to Postgres?

I saw some posts from 2004 that made it sound like it was imminent, but I
guess something went wrong? I believe the WITH clause is a pre-requisite
for recursive SQL, however I do find the WITH clause also very useful in
decomposing very complex SQL into understandable chunks.

--
View this message in context: http://www.nabble.com/recursive-SQL-and-with-clause-tf2638088.html#a7363779
Sent from the PostgreSQL - sql mailing list archive at Nabble.com.

After takin a swig o' Arrakan spice grog, chrisj(dot)wood(at)sympatico(dot)ca (chrisj) belched out:
> I was just wondering when we could reasonably expect recursive SQL to be
> added to Postgres?
>
> I saw some posts from 2004 that made it sound like it was imminent,
> but I guess something went wrong? I believe the WITH clause is a
> pre-requisite for recursive SQL, however I do find the WITH clause
> also very useful in decomposing very complex SQL into understandable
> chunks.

If I recall correctly, Jim Nasby was considering it; he hadn't heard
much interest back, and got to other things in the 8.2 cycle.

There has been some discussion on strategy for an approach to it for
the 8.3 cycle; you can expect that not to progress much 'til 8.2.0
gets released.

Bringing it back up on pgsql.hackers, some time soon thereafter, would
be not the worst idea of all time :-).
--
(format nil "~S(at)~S" "cbbrowne" "gmail.com")
http://linuxdatabases.info/info/wp.html
Programming is one of the most difficult branches of applied
mathematics; the poorer mathematicians had better remain pure
mathematicians. -- Edsger W. Dijkstra

On 11/15/06, Christopher Browne <cbbrowne(at)acm(dot)org> wrote:
> If I recall correctly, Jim Nasby was considering it; he hadn't heard
> much interest back, and got to other things in the 8.2 cycle.

I was working on it for 8.2, but it didn't make it. Mark Cave-Ayland
will probably be picking it up for 8.3.

--
Jonah H. Harris, Software Architect | phone: 732.331.1300
EnterpriseDB Corporation | fax: 732.331.1301
33 Wood Ave S, 2nd Floor | jharris(at)enterprisedb(dot)com
Iselin, New Jersey 08830 | http://www.enterprisedb.com/