From c6ce4c13229c64c01393c86be220b532a0244d87 Mon Sep 17 00:00:00 2001 From: Bruce Momjian Date: Thu, 16 Aug 2012 11:32:22 -0400 Subject: [PATCH] In docs, clarify that, without ORDER BY, the window frame is all rows in the partition. --- doc/src/sgml/syntax.sgml | 7 ++++--- 1 file changed, 4 insertions(+), 3 deletions(-) diff --git a/doc/src/sgml/syntax.sgml b/doc/src/sgml/syntax.sgml index a01f9b5fc4..067c31b2d8 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 RANGE UNBOUNDED PRECEDING, which is the same as 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 ORDER BY, - or all partition rows if there is no ORDER BY. + CURRENT ROW. With ORDER BY, this sets the frame to + be all rows from partition start up through the current row's + last peer. Without ORDER BY, all partition rows are + included in the window frame. -- 2.40.0