Commit276a8f4

committed

Additional cross-references to window functions documentation.

Erik Rijkers

1 parent97301ab commit276a8f4Copy full SHA for 276a8f4

File tree

-5

lines changed

-5

lines changed

Lines changed: 2 additions & 1 deletion

Original file line number	Diff line number	Diff line change
`@@ -1,4 +1,4 @@`
`1`		`-<!-- $PostgreSQL: pgsql/doc/src/sgml/advanced.sgml,v 1.60 2010/04/0307:22:52 petere Exp $ -->`
	`1`	`+<!-- $PostgreSQL: pgsql/doc/src/sgml/advanced.sgml,v 1.61 2010/07/0302:57:46 rhaas Exp $ -->`
`2`	`2`
`3`	`3`	`<chapter id="tutorial-advanced">`
`4`	`4`	`<title>Advanced Features</title>`
`@@ -554,6 +554,7 @@ SELECT sum(salary) OVER w, avg(salary) OVER w`
`554`	`554`	`<para>`
`555`	`555`	`More details about window functions can be found in`
`556`	`556`	`<xref linkend="syntax-window-functions">,`
	`557`	`+ <xref linkend="functions-window">,`
`557`	`558`	`<xref linkend="queries-window">, and the`
`558`	`559`	`<xref linkend="sql-select"> reference page.`
`559`	`560`	`</para>`

Lines changed: 3 additions & 2 deletions

Original file line number	Diff line number	Diff line change
`@@ -1,4 +1,4 @@`
`1`		`-<!-- $PostgreSQL: pgsql/doc/src/sgml/queries.sgml,v 1.57 2010/04/0307:22:55 petere Exp $ -->`
	`1`	`+<!-- $PostgreSQL: pgsql/doc/src/sgml/queries.sgml,v 1.58 2010/07/0302:57:46 rhaas Exp $ -->`
`2`	`2`
`3`	`3`	`<chapter id="queries">`
`4`	`4`	`<title>Queries</title>`
`@@ -979,7 +979,8 @@ SELECT product_id, p.name, (sum(s.units) * (p.price - p.cost)) AS profit`
`979`	`979`
`980`	`980`	`<para>`
`981`	`981`	`If the query contains any window functions (see`
`982`		`- <xref linkend="tutorial-window"> and`
	`982`	`+ <xref linkend="tutorial-window">,`
	`983`	`+ <xref linkend="functions-window"> and`
`983`	`984`	`<xref linkend="syntax-window-functions">), these functions are evaluated`
`984`	`985`	`after any grouping, aggregation, and <literal>HAVING</> filtering is`
`985`	`986`	`performed. That is, if the query uses any aggregates, <literal>GROUP`

Lines changed: 3 additions & 2 deletions

Original file line number	Diff line number	Diff line change
`@@ -1,4 +1,4 @@`
`1`		`-<!-- $PostgreSQL: pgsql/doc/src/sgml/syntax.sgml,v 1.146 2010/06/09 16:43:47 alvherre Exp $ -->`
	`1`	`+<!-- $PostgreSQL: pgsql/doc/src/sgml/syntax.sgml,v 1.147 2010/07/03 02:57:46 rhaas Exp $ -->`
`2`	`2`
`3`	`3`	`<chapter id="sql-syntax">`
`4`	`4`	`<title>SQL Syntax</title>`
`@@ -1761,7 +1761,8 @@ UNBOUNDED FOLLOWING`
`1761`	`1761`
`1762`	`1762`	`<para>`
`1763`	`1763`	`More information about window functions can be found in`
`1764`		`- <xref linkend="tutorial-window"> and`
	`1764`	`+ <xref linkend="tutorial-window">,`
	`1765`	`+ <xref linkend="functions-window">,`
`1765`	`1766`	`<xref linkend="queries-window">.`
`1766`	`1767`	`</para>`
`1767`	`1768`	`</sect2>`

Comments

(0)