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
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. |