On Fri, Mar 07, 2008 at 06:50:17AM -0800, Matt Culbreth wrote:
> I might have missed this somewhere, but PostgreSQL doesn't presently
> support the cumulative/running aggregate function SUM() OVER
> (PARTITION BY) syntax that Oracle does, right?
you might find this useful:
http://www.depesz.com/index.php/2007/08/17/rownum-anyone-cumulative-sum-in-one-query/
please also read comments.
depesz
--
quicksil1er: "postgres is excellent, but like any DB it requires a
highly paid DBA. here's my CV!" :)
http://www.depesz.com/ - blog dla ciebie (i moje CV)