Excerpts from Hitoshi Harada's message of mié sep 22 12:54:45 -0400 2010:
> > Maybe we can find some better wording of the above?
>
> Your point is true, but I believe it's still ok because the section is
> a tutorial for novices. If you start to explain everything here,
> readers don't want to read it to the end.
We had this exact question in the spanish list two weeks ago. I also
suggest that we need to explain this a bit more explicitely.
Actually the spanish question involved a PARTITION BY / ORDER BY clause,
and the difference showed up not because of the existance of ORDER BY
alone, but by whether the ORDER BY had the same columns than PARTITION
BY or more. Here it is:
http://archives.postgresql.org/message-id/OF7DB68F53.5DA80480-ON8625779F.0058B555-8625779F.005917FA@correogs.com.mx
(The archive is a bit confusing because the results appear as images at
the bottom of the email, instead of being interspersed with the text.)
--
Álvaro Herrera <alvherre@commandprompt.com>
The PostgreSQL Company - Command Prompt, Inc.
PostgreSQL Replication, Consulting, Custom Development, 24x7 support