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?

Thanks,
Sean

---------------------------(end of broadcast)---------------------------
TIP 6: explain analyze is your friend

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-hac...1/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