Postgres Pro
Downloads
Home   >   mailing lists

Re: [PATCH] Negative Transition Aggregate Functions (WIP) - Mailing list pgsql-hackers

From David Rowley
Subject Re: [PATCH] Negative Transition Aggregate Functions (WIP)
Date
Msg-id CAApHDvooC7xZcefh8uejQv4tqc-jVY7MFm_BV0Ln7X3g-Cry_w@mail.gmail.com
Whole thread Raw
In response to Re: [PATCH] Negative Transition Aggregate Functions (WIP)  ("Erik Rijkers" <er@xs4all.nl>)
List pgsql-hackers
Tree view
On Fri, Jan 3, 2014 at 5:33 AM, Erik Rijkers <er@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). 

pgsql-hackers by date:

Previous
From: Tom Lane
Date:
Subject: Re: preserving forensic information when we freeze
Next
From: Tom Lane
Date:
Subject: Re: preserving forensic information when we freeze