From: Christopher Browne <cbbrowne@acm.org>
To: pgsql-sql@postgresql.org
Subject: Re: recursive SQL and with clause
Date: Wed, 15 Nov 2006 21:38:57 -0500
Message-ID: <87velgazem.fsf@wolfe.cbbrowne.com> (raw)
References: <7363779.post@talk.nabble.com>
After takin a swig o' Arrakan spice grog, chrisj.wood@sympatico.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@~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
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-sql@postgresql.org
Cc: cbbrowne@acm.org
Subject: Re: recursive SQL and with clause
In-Reply-To: <87velgazem.fsf@wolfe.cbbrowne.com>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox