From 276a8f4e99188f0307cd747c2e2575f95626d893 Mon Sep 17 00:00:00 2001 From: Robert Haas Date: Sat, 3 Jul 2010 02:57:46 +0000 Subject: [PATCH] Additional cross-references to window functions documentation. Erik Rijkers --- doc/src/sgml/advanced.sgml | 3 ++- doc/src/sgml/queries.sgml | 5 +++-- 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 6bb6ca99d1..38045b51fd 100644 --- a/doc/src/sgml/advanced.sgml +++ b/doc/src/sgml/advanced.sgml @@ -1,4 +1,4 @@ - + Advanced Features @@ -554,6 +554,7 @@ SELECT sum(salary) OVER w, avg(salary) OVER w More details about window functions can be found in , + , , and the reference page. diff --git a/doc/src/sgml/queries.sgml b/doc/src/sgml/queries.sgml index 5e165a38f2..26bc224384 100644 --- a/doc/src/sgml/queries.sgml +++ b/doc/src/sgml/queries.sgml @@ -1,4 +1,4 @@ - + Queries @@ -979,7 +979,8 @@ SELECT product_id, p.name, (sum(s.units) * (p.price - p.cost)) AS profit If the query contains any window functions (see - and + , + and ), these functions are evaluated after any grouping, aggregation, and HAVING filtering is performed. That is, if the query uses any aggregates, GROUP diff --git a/doc/src/sgml/syntax.sgml b/doc/src/sgml/syntax.sgml index c74ad264e7..bf63425a71 100644 --- a/doc/src/sgml/syntax.sgml +++ b/doc/src/sgml/syntax.sgml @@ -1,4 +1,4 @@ - + SQL Syntax @@ -1761,7 +1761,8 @@ UNBOUNDED FOLLOWING More information about window functions can be found in - and + , + , . -- 2.40.0