links to functions-window

From: "Erik Rijkers" <er(at)xs4all(dot)nl>
To: pgsql-docs(at)postgresql(dot)org
Subject: links to functions-window
Date: 2010-07-01 17:56:48
Message-ID: f585ef563f416025c516dad8889f26ce.squirrel@webmail.xs4all.nl
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-docs

There is a curious oversight in the windows documentation, where
the several window pages are not linking to the functions-window
(where the actual functions are enumerated).

That makes it easy to overlook for instance, a function like row_number() (not mentioned in other
examples).

I think at least the below three links should be added.

Erik Rijkers

--- advanced.sgml.orig 2010-07-01 19:02:56.000000000 +0200
+++ advanced.sgml 2010-07-01 19:05:07.000000000 +0200
@@ -554,6 +554,7 @@
<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>

--- syntax.sgml.orig 2010-07-01 19:06:08.000000000 +0200
+++ syntax.sgml 2010-07-01 19:06:42.000000000 +0200
@@ -1761,7 +1761,8 @@

<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>

--- queries.sgml.orig 2010-07-01 19:46:32.000000000 +0200
+++ queries.sgml 2010-07-01 19:47:16.000000000 +0200
@@ -979,7 +979,8 @@

<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

Responses

Browse pgsql-docs by date

  From Date Subject
Next Message Rafael Martinez 2010-07-01 19:11:31 Re: Documentation and explanatory diagrams
Previous Message Bruce Momjian 2010-07-01 02:33:19 Re: typo in release note