Received: from localhost (mx1.hub.org [200.46.208.251]) by postgresql.org (Postfix) with ESMTP id 1A20A9F9ECF for ; Wed, 15 Nov 2006 22:45:41 -0400 (AST) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.208.251]) (amavisd-new, port 10024) with ESMTP id 74096-08 for ; Wed, 15 Nov 2006 22:45:34 -0400 (AST) X-Greylist: from auto-whitelisted by SQLgrey- Received: from floppy.pyrenet.fr (floppy.pyrenet.fr [194.116.145.2]) by postgresql.org (Postfix) with ESMTP id B8F2A9F9EEF for ; Wed, 15 Nov 2006 22:45:33 -0400 (AST) Received: by floppy.pyrenet.fr (Postfix, from userid 106) id 57BB330DF9; Thu, 16 Nov 2006 03:45:31 +0100 (MET) From: Christopher Browne X-Newsgroups: pgsql.sql Subject: Re: recursive SQL and with clause Date: Wed, 15 Nov 2006 21:38:57 -0500 Organization: cbbrowne Computing Inc Lines: 25 Message-ID: <87velgazem.fsf@wolfe.cbbrowne.com> References: <7363779.post@talk.nabble.com> Mime-Version: 1.0 Content-Type: text/plain; charset=us-ascii X-Complaints-To: usenet@news.hub.org X-message-flag: Outlook is rather hackable, isn't it? X-Home-Page: http://www.cbbrowne.com/info/ X-Affero: http://svcs.affero.net/rm.php?r=cbbrowne User-Agent: Gnus/5.1007 (Gnus v5.10.7) XEmacs/21.4.19 (linux) Cancel-Lock: sha1:EfQahTyWhGnG73cjoyvB0AGhyXQ= To: pgsql-sql@postgresql.org X-Virus-Scanned: Maia Mailguard 1.0.1 X-Archive-Number: 200611/161 X-Sequence-Number: 26813 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