postgres.git / summary / log / commit / refs

commit    d3b372e92d4efdd6f63da35996f04ff009c932b5
Author:   Robert Haas <rhaas@postgresql.org>
Date:     Fri Jan 21 17:57:49 2011 +0000
First released in: 9.1.0

    Emphasize where OVER needs to be when using a window function.
    
    Jeff Turner


doc/src/sgml/advanced.sgml | 2 +- 1 file changed, 1 insertion(+), 1 deletion(-) diff --git a/doc/src/sgml/advanced.sgml b/doc/src/sgml/advanced.sgml index 784b40a3621..9cb717313a8 100644 --- a/doc/src/sgml/advanced.sgml +++ b/doc/src/sgml/advanced.sgml @@ -371,7 +371,7 @@ SELECT depname, empno, salary, avg(salary) OVER (PARTITION BY depname) FROM emps <para> A window function call always contains an <literal>OVER</> clause - following the window function's name and argument(s). This is what + directly following the window function's name and argument(s). This is what syntactically distinguishes it from a regular function or aggregate function. The <literal>OVER</> clause determines exactly how the rows of the query are split up for processing by the window function. [parent: 5925aa09a911]