Postgres Pro
Downloads
Home   >   mailing lists

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

From Tom Lane
Subject Re: [PATCH] Negative Transition Aggregate Functions (WIP)
Date
Msg-id 25017.1387073338@sss.pgh.pa.us
Whole thread Raw
In response to Re: [PATCH] Negative Transition Aggregate Functions (WIP)  (Tom Lane <tgl@sss.pgh.pa.us>)
Responses Re: [PATCH] Negative Transition Aggregate Functions (WIP)
Re: [PATCH] Negative Transition Aggregate Functions (WIP)
List pgsql-hackers
Tree view 
I wrote:
> It's not so good with two-row windows though:

Actually, carrying that example a bit further makes the point even more
forcefully:
   Table       correct sum of          negative-transition               this + next value       result   1e20
1e20                   1e20 + 1 = 1e20   1           1                       1e20 - 1e20 + 0 = 0   0           0
              0 - 1 + 0 = -1   0           1                       -1 - 0 + 1 = 0   1
 

Those last few answers are completely corrupt.
        regards, tom lane

pgsql-hackers by date:

Previous
From: Tom Lane
Date:
Subject: Re: [PATCH] Negative Transition Aggregate Functions (WIP)
Next
From: Tatsuo Ishii
Date:
Subject: Re: encoding name "SHIFT_JIS" is absent in chklocale.c