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) -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
