From: | "Robert Haas" <robertmhaas(at)gmail(dot)com> |
---|---|
To: | PostgreSQL-development <pgsql-hackers(at)postgresql(dot)org> |
Subject: | window function docs |
Date: | 2008-12-29 14:43:58 |
Message-ID: | 603c8f070812290643g23344667p48b58b4fefea75ba@mail.gmail.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-hackers |
Section 7.2.4 of the docs, third paragraph, currently reads:
> Currently, use of window functions always forces sorting, and so the query output will be ordered according to one or another of the window functions' PARTITION BY/ORDER
> BY clauses. It is not recommendable to rely on this, however. Use an explicit top-level ORDER BY clause if you want to be sure the results are sorted in a particular way.
Recommendable is not a commonly used word in English, and I think the
rest of the paragraph can be tightened up a bit. Maybe something like
this:
Currently, use of window functions always forces sorting, so the query
output will be ordered according to one or another of the window
functions' PARTITION BY/ORDER BY clauses. However, this may change in
the future, so you should use an explicit top-level ORDER BY clause if
you want the results sorted in a particular way.
Also, section 3.5 of the docs does not references any of the other
sections that talk about window functions (7.2.4, 4.2.8, 9.19), and
7.2.4 does not reference 9.19 either. I'm not sure what the policy on
cross-references but it took me a bit to find everything.
...Robert
From | Date | Subject | |
---|---|---|---|
Next Message | Peter Eisentraut | 2008-12-29 14:48:29 | Re: Several tags around PostgreSQL 7.1 broken |
Previous Message | Kurt Roeckx | 2008-12-29 14:24:16 | Re: Gcc 4.4 causes abort in plpython. |