diff options
| author | Robert Haas <rhaas@postgresql.org> | 2010-07-03 02:57:46 +0000 |
|---|---|---|
| committer | Robert Haas <rhaas@postgresql.org> | 2010-07-03 02:57:46 +0000 |
| commit | 276a8f4e99188f0307cd747c2e2575f95626d893 (patch) | |
| tree | b9ac47cc78c16e013f05060bda1134213ac8c996 | |
| parent | 97301ab1899328462d772108f9cd70547a9ab03d (diff) | |
| download | postgresql-276a8f4e99188f0307cd747c2e2575f95626d893.tar.gz postgresql-276a8f4e99188f0307cd747c2e2575f95626d893.zip | |
Additional cross-references to window functions documentation.
Erik Rijkers
| -rw-r--r-- | doc/src/sgml/advanced.sgml | 3 | ||||
| -rw-r--r-- | doc/src/sgml/queries.sgml | 5 | ||||
| -rw-r--r-- | doc/src/sgml/syntax.sgml | 5 |
3 files changed, 8 insertions, 5 deletions
diff --git a/doc/src/sgml/advanced.sgml b/doc/src/sgml/advanced.sgml index 6bb6ca99d10..38045b51fdd 100644 --- a/doc/src/sgml/advanced.sgml +++ b/doc/src/sgml/advanced.sgml @@ -1,4 +1,4 @@ -<!-- $PostgreSQL: pgsql/doc/src/sgml/advanced.sgml,v 1.60 2010/04/03 07:22:52 petere Exp $ --> +<!-- $PostgreSQL: pgsql/doc/src/sgml/advanced.sgml,v 1.61 2010/07/03 02:57:46 rhaas Exp $ --> <chapter id="tutorial-advanced"> <title>Advanced Features</title> @@ -554,6 +554,7 @@ SELECT sum(salary) OVER w, avg(salary) OVER w <para> More details about window functions can be found in <xref linkend="syntax-window-functions">, + <xref linkend="functions-window">, <xref linkend="queries-window">, and the <xref linkend="sql-select"> reference page. </para> diff --git a/doc/src/sgml/queries.sgml b/doc/src/sgml/queries.sgml index 5e165a38f2b..26bc2243843 100644 --- a/doc/src/sgml/queries.sgml +++ b/doc/src/sgml/queries.sgml @@ -1,4 +1,4 @@ -<!-- $PostgreSQL: pgsql/doc/src/sgml/queries.sgml,v 1.57 2010/04/03 07:22:55 petere Exp $ --> +<!-- $PostgreSQL: pgsql/doc/src/sgml/queries.sgml,v 1.58 2010/07/03 02:57:46 rhaas Exp $ --> <chapter id="queries"> <title>Queries</title> @@ -979,7 +979,8 @@ SELECT product_id, p.name, (sum(s.units) * (p.price - p.cost)) AS profit <para> If the query contains any window functions (see - <xref linkend="tutorial-window"> and + <xref linkend="tutorial-window">, + <xref linkend="functions-window"> and <xref linkend="syntax-window-functions">), these functions are evaluated after any grouping, aggregation, and <literal>HAVING</> filtering is performed. That is, if the query uses any aggregates, <literal>GROUP diff --git a/doc/src/sgml/syntax.sgml b/doc/src/sgml/syntax.sgml index c74ad264e7b..bf63425a719 100644 --- a/doc/src/sgml/syntax.sgml +++ b/doc/src/sgml/syntax.sgml @@ -1,4 +1,4 @@ -<!-- $PostgreSQL: pgsql/doc/src/sgml/syntax.sgml,v 1.146 2010/06/09 16:43:47 alvherre Exp $ --> +<!-- $PostgreSQL: pgsql/doc/src/sgml/syntax.sgml,v 1.147 2010/07/03 02:57:46 rhaas Exp $ --> <chapter id="sql-syntax"> <title>SQL Syntax</title> @@ -1761,7 +1761,8 @@ UNBOUNDED FOLLOWING <para> More information about window functions can be found in - <xref linkend="tutorial-window"> and + <xref linkend="tutorial-window">, + <xref linkend="functions-window">, <xref linkend="queries-window">. </para> </sect2> |