Received: from maia.hub.org (maia-2.hub.org [200.46.204.251])
	by mail.postgresql.org (Postfix) with ESMTP id 61C0F632EA0
	for <pgsql-docs-postgresql.org@mail.postgresql.org>;
	Thu,  1 Jul 2010 14:56:57 -0300 (ADT)
Received: from mail.postgresql.org ([200.46.204.86])
	by maia.hub.org (mx1.hub.org [200.46.204.251]) (amavisd-maia,
	port 10024) with ESMTP id 39013-03 for
	<pgsql-docs-postgresql.org@mail.postgresql.org>;
	Thu,  1 Jul 2010 17:56:50 +0000 (UTC)
X-Greylist: from auto-whitelisted by SQLgrey-1.7.6
Received: from smtp-vbr12.xs4all.nl (smtp-vbr12.xs4all.nl [194.109.24.32])
	by mail.postgresql.org (Postfix) with ESMTP id 4B9E0632D4D
	for <pgsql-docs@postgresql.org>; Thu,  1 Jul 2010 14:56:49 -0300 (ADT)
Received: from webmail.xs4all.nl (dovemail12.xs4all.nl [194.109.26.14])
	by smtp-vbr12.xs4all.nl (8.13.8/8.13.8) with ESMTP id o61HumKo027717
	for <pgsql-docs@postgresql.org>; Thu, 1 Jul 2010 19:56:48 +0200 (CEST)
	(envelope-from er@xs4all.nl)
Received: from 156.83.1.88 (SquirrelMail authenticated user er)
	by webmail.xs4all.nl with HTTP; Thu, 1 Jul 2010 19:56:48 +0200
Message-ID: <f585ef563f416025c516dad8889f26ce.squirrel@webmail.xs4all.nl>
Date: Thu, 1 Jul 2010 19:56:48 +0200
Subject: links to functions-window
From: "Erik Rijkers" <er@xs4all.nl>
To: pgsql-docs@postgresql.org
User-Agent: SquirrelMail/1.4.18
MIME-Version: 1.0
Content-Type: text/plain;charset=iso-8859-1
Content-Transfer-Encoding: 8bit
X-Virus-Scanned: by XS4ALL Virus Scanner
X-Virus-Scanned: Maia Mailguard 1.0.1
X-Spam-Status: No, hits=0.79 tagged_above=-5 required=5 tests=BAYES_50=0.8,
	RCVD_IN_DNSWL_NONE=-0.0001, T_RP_MATCHES_RCVD=-0.01
X-Spam-Level: 
X-Archive-Number: 201007/1
X-Sequence-Number: 5657

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