Re: Documentation, window functions

From: Alvaro Herrera <alvherre(at)commandprompt(dot)com>
To: Hitoshi Harada <umi(dot)tanuki(at)gmail(dot)com>
Cc: Dennis Björklund <db(at)zigo(dot)dhs(dot)org>, pgsql-hackers <pgsql-hackers(at)postgresql(dot)org>
Subject: Re: Documentation, window functions
Date: 2010-09-22 17:09:23
Message-ID: 1285175121-sup-1336@alvh.no-ip.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

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(at)commandprompt(dot)com>
The PostgreSQL Company - Command Prompt, Inc.
PostgreSQL Replication, Consulting, Custom Development, 24x7 support

In response to

Browse pgsql-hackers by date

  From Date Subject
Next Message Heikki Linnakangas 2010-09-22 17:12:31 Re: Configuring synchronous replication
Previous Message Joshua D. Drake 2010-09-22 17:09:18 Re: Configuring synchronous replication