"Pavel Stehule" <pavel.steh...@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 -- Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-hackers