pg.ddx.io pgsql-sql@postgresql.org mailing list archive
help / color / mirror / Atom feedrecursive SQL and with clause
3+ messages / 3 participants
[nested] [flat]
* recursive SQL and with clause
@ 2006-11-15 18:45 chrisj <chrisj.wood@sympatico.ca>
2006-11-16 02:38 ` Re: recursive SQL and with clause Christopher Browne <cbbrowne@acm.org>
0 siblings, 1 reply; 3+ messages in thread
From: chrisj @ 2006-11-15 18:45 UTC (permalink / raw)
To: pgsql-sql
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.
^ permalink raw reply [nested|flat] 3+ messages in thread
* Re: recursive SQL and with clause
2006-11-15 18:45 recursive SQL and with clause chrisj <chrisj.wood@sympatico.ca>
@ 2006-11-16 02:38 ` Christopher Browne <cbbrowne@acm.org>
2006-11-16 13:18 ` Re: recursive SQL and with clause Jonah H. Harris <jonah.harris@gmail.com>
0 siblings, 1 reply; 3+ messages in thread
From: Christopher Browne @ 2006-11-16 02:38 UTC (permalink / raw)
To: pgsql-sql
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
^ permalink raw reply [nested|flat] 3+ messages in thread
* Re: recursive SQL and with clause
2006-11-15 18:45 recursive SQL and with clause chrisj <chrisj.wood@sympatico.ca>
2006-11-16 02:38 ` Re: recursive SQL and with clause Christopher Browne <cbbrowne@acm.org>
@ 2006-11-16 13:18 ` Jonah H. Harris <jonah.harris@gmail.com>
0 siblings, 0 replies; 3+ messages in thread
From: Jonah H. Harris @ 2006-11-16 13:18 UTC (permalink / raw)
To: Christopher Browne <cbbrowne@acm.org>; +Cc: pgsql-sql
On 11/15/06, Christopher Browne <cbbrowne@acm.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@enterprisedb.com
Iselin, New Jersey 08830 | http://www.enterprisedb.com/
^ permalink raw reply [nested|flat] 3+ messages in thread
end of thread, other threads:[~2006-11-16 13:18 UTC | newest]
Thread overview: 3+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2006-11-15 18:45 recursive SQL and with clause chrisj <chrisj.wood@sympatico.ca>
2006-11-16 02:38 ` Christopher Browne <cbbrowne@acm.org>
2006-11-16 13:18 ` Jonah H. Harris <jonah.harris@gmail.com>
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