Re: recursive SQL and with clause

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