Re: Window Functions patch v06

2008/10/11 Hitoshi Harada <umi.tanuki@gmail.com>
>
> I'm afraid the patch was too huge, trying to send it again without attachment...
>
> I made up my mind to scratch former window functions and redesigned
> completely new execution model, based on the discussion with Heikki.
> Attached is the v06 against HEAD today.

Small nit - I get this from the following query:

postgres=# select a, sum(a) over (order by a) from generate_series(1,10) a;a  | sum
----+----- 1 |  55 2 |  55 3 |  55 4 |  55 5 |  55 6 |  55 7 |  55 8 |  55 9 |  5510 |  55
(10 rows)

From what I can tell of the spec, the 'sum' column should contain a
running sum (ie 1,3,6 etc). You mention that window frames haven't
been implemented, but it seems like this case should return an error
rather than the wrong results...

Thanks,
Ian