diff options
| author | Bruce Momjian <bruce@momjian.us> | 2012-08-16 11:32:22 -0400 |
|---|---|---|
| committer | Bruce Momjian <bruce@momjian.us> | 2012-08-16 11:32:22 -0400 |
| commit | c6ce4c13229c64c01393c86be220b532a0244d87 (patch) | |
| tree | 8fa33ff0ed774d115ac41c66336242ebbe79f5a6 /doc/src | |
| parent | 5c1b2f5daa678b94861ab29ccc0252e4f2eb40ff (diff) | |
| download | postgresql-c6ce4c13229c64c01393c86be220b532a0244d87.tar.gz postgresql-c6ce4c13229c64c01393c86be220b532a0244d87.zip | |
In docs, clarify that, without ORDER BY, the window frame is all rows in
the partition.
Diffstat (limited to 'doc/src')
| -rw-r--r-- | doc/src/sgml/syntax.sgml | 7 |
1 files changed, 4 insertions, 3 deletions
diff --git a/doc/src/sgml/syntax.sgml b/doc/src/sgml/syntax.sgml index a01f9b5fc4e..067c31b2d87 100644 --- a/doc/src/sgml/syntax.sgml +++ b/doc/src/sgml/syntax.sgml @@ -1794,9 +1794,10 @@ UNBOUNDED FOLLOWING window functions that act on the frame instead of the whole partition. The default framing option is <literal>RANGE UNBOUNDED PRECEDING</>, which is the same as <literal>RANGE BETWEEN UNBOUNDED PRECEDING AND - CURRENT ROW</>. This sets the frame to be all rows from the partition start - up through the current row's last peer as specified by <literal>ORDER BY</>, - or all partition rows if there is no <literal>ORDER BY</>. + CURRENT ROW</>. With <literal>ORDER BY</>, this sets the frame to + be all rows from partition start up through the current row's + last peer. Without <literal>ORDER BY</>, all partition rows are + included in the window frame. </para> <para> |