Received: from localhost (unknown [200.46.204.187]) by postgresql.org (Postfix) with ESMTP id 0CC549FA561 for ; Fri, 31 Aug 2007 13:04:14 -0300 (ADT) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.204.187]) (amavisd-maia, port 10024) with ESMTP id 36769-06 for ; Fri, 31 Aug 2007 13:04:13 -0300 (ADT) X-Greylist: from auto-whitelisted by SQLgrey-1.7.5 Received: from floppy.pyrenet.fr (news.pyrenet.fr [194.116.145.2]) by postgresql.org (Postfix) with ESMTP id 18B219FA484 for ; Fri, 31 Aug 2007 13:04:13 -0300 (ADT) Received: by floppy.pyrenet.fr (Postfix, from userid 106) id 3DE2431444; Fri, 31 Aug 2007 18:04:06 +0200 (MET DST) From: Chris Browne X-Newsgroups: pgsql.sql Subject: Re: Reporting functions (OLAP) Date: Fri, 31 Aug 2007 11:09:48 -0400 Organization: cbbrowne Computing Inc Lines: 25 Message-ID: <60abs7eo5f.fsf@dba2.int.libertyrms.com> References: <46D739E4.1020605@mail.nih.gov> Mime-Version: 1.0 Content-Type: text/plain; charset=us-ascii X-Complaints-To: usenet@news.hub.org User-Agent: Gnus/5.1008 (Gnus v5.10.8) XEmacs/21.4.20 (linux) Cancel-Lock: sha1:4Ok5e5AfDS1c3KOhc4jHzyztIms= To: pgsql-sql@postgresql.org X-Virus-Scanned: Maia Mailguard 1.0.1 X-Archive-Number: 200708/267 X-Sequence-Number: 29205 sdavis2@mail.nih.gov (Sean Davis) writes: > I am looking for reporting extensions such as windowing, ranking, > leads/lags, etc. for postgresql. A quick google search turned up > some "working on it" type results, but I was wondering if anything > actually existed up to this point? No, nothing exists to this point. Efforts are presently ongoing to get version 8.3 out the door, and, for now, that is The High Priority. Once 8.3 is released, people who have been working on 8.3 matters can shift attention to new functionality. SQL 2003 "windowing" is on the TODO list: http://www.postgresql.org/docs/faqs.TODO.html Some discussions of this... http://svr5.postgresql.org/pgsql-hackers/2004-11/msg01093.php -- output = ("cbbrowne" "@" "cbbrowne.com") http://linuxdatabases.info/info/linuxdistributions.html "Every sufficiently unreadable programming language contains a reimplementation of APL and/or INTERCAL." -- Greenspun's Eleventh Rule of Programming