Re: sum() over (partition by order) question - Mailing list pgsql-hackers

"Pavel Stehule" <pavel.stehule@gmail.com> writes:
> so I have to modify query to get expected values
> postgres=# select a, b, last_value(a) over (partition by b),
> last_value(a) over (partition by b order by a  RANGE BETWEEN UNBOUNDED
> PRECEDING AND UNBOUNDED FOLLOWING) from foo;

> it should be noticed in doc?

It is --- see the comments at the bottom of

http://developer.postgresql.org/pgdocs/postgres/functions-window.html
        regards, tom lane