On Wed, Apr 15, 2009 at 11:09:49AM +0100, Shug Boabby wrote: > Anyone have any ideas how to do this? I'm able to do it > programmatically, but it's slow. Optimally I'd like to be able to do > this in the DB. As you can see, it's a little trickier that the usual > aggregate function with a GROUP BY and HAVING.
this is called cumulative sum, and can be done quite easily. check this blogpost (but also its comments! - the c function is not necessary!) http://www.depesz.com/index.php/2007/08/17/rownum-anyone-cumulative-sum-in-one-query/ depesz -- Linkedin: http://www.linkedin.com/in/depesz / blog: http://www.depesz.com/ jid/gtalk: dep...@depesz.com / aim:depeszhdl / skype:depesz_hdl / gg:6749007 -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
