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

Поиск
Список
Период
Сортировка
От David Rowley
Тема Re: [PATCH] Negative Transition Aggregate Functions (WIP)
Дата
Msg-id CAApHDvooC7xZcefh8uejQv4tqc-jVY7MFm_BV0Ln7X3g-Cry_w@mail.gmail.com
обсуждение исходный текст
Ответ на Re: [PATCH] Negative Transition Aggregate Functions (WIP)  ("Erik Rijkers" <er@xs4all.nl>)
Список pgsql-hackers
Дерево обсуждения
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 по дате отправления:

Предыдущее
От: Tom Lane
Дата:
Сообщение: Re: preserving forensic information when we freeze
Следующее
От: Tom Lane
Дата:
Сообщение: Re: preserving forensic information when we freeze