Re: [PATCH] Negative Transition Aggregate Functions (WIP)

On Fri, Jan 3, 2014 at 5:33 AM, Erik Rijkers <er(at)xs4all(dot)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).