On Fri, Jan 3, 2014 at 5:33 AM, Erik Rijkers <e...@xs4all.nl> wrote:
> *** /var/data1/pg_stuff/pg_sandbox/pgsql.inverse/src/ > test/regress/expected/window.out 2014-01-02 16:19:48.000000000 +0100 > --- > /var/data1/pg_stuff/pg_sandbox/pgsql.inverse/src/test/regress/results/window.out > 2014-01-02 16:21:43.000000000 +0100 > *************** > *** 1188,1195 **** > sum > ------ > 6.01 > ! 5 > ! 3 > (3 rows) > > SELECT i,COUNT(v) OVER (ORDER BY i ROWS BETWEEN CURRENT ROW AND > UNBOUNDED FOLLOWING) > --- 1188,1195 ---- > sum > ------ > 6.01 > ! 5.00 > ! 3.00 > (3 rows) > > I've left those failures in for now in the hope to generate some discussion on if we can inverse transition for sum(numeric). Please see my email before the previous one for details. To fix it pg_aggregate.h just needs to be changed to remove the inverse transition for sum(numeric).