Documentation, window functions

From: Dennis Björklund <db(at)zigo(dot)dhs(dot)org>
To: pgsql-hackers(at)postgresql(dot)org
Subject: Documentation, window functions
Date: 2010-09-22 10:03:47
Message-ID: e2ba8fee01f49aab7a6b67be1fde2424.squirrel@zigo.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

In

http://www.postgresql.org/docs/9.0/static/tutorial-window.html

it say

"Although avg will produce the same result no matter what order it
processes the partition's rows in, this is not true of all window
functions. When needed, you can control that order using ORDER BY within
OVER."

While it's true that avg() produce the same result no matter what order. A
ORDER BY clause will affect what rows are included in the computation and
thus change the result (the default window frame is
RANGE BETWEEN UNBOUNDED PRECEDING AND CURRENT ROW). So one can not in
general add an ORDER BY to the example in the tutorial and get the same
result as without an ORDER BY.

Maybe we can find some better wording of the above?

/Dennis

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Magnus Hagander 2010-09-22 10:11:55 Re: snapshot generation broken
Previous Message Peter Eisentraut 2010-09-22 09:45:22 Re: BUG #5661: The character encoding in logfile is confusing.