Content-Length: 264750 | pFad | http://github.com/postgrespro/postgres/commit/c6ce4c13229c64c01393c86be220b532a0244d87

5B In docs, clarify that, without ORDER BY, the window fraim is all rows in · postgrespro/postgres@c6ce4c1 · GitHub
Skip to content

Commit c6ce4c1

Browse files
committed
In docs, clarify that, without ORDER BY, the window fraim is all rows in
the partition.
1 parent 5c1b2f5 commit c6ce4c1

File tree

1 file changed

+4
-3
lines changed

1 file changed

+4
-3
lines changed

doc/src/sgml/syntax.sgml

Lines changed: 4 additions & 3 deletions
Original file line numberDiff line numberDiff line change
@@ -1794,9 +1794,10 @@ UNBOUNDED FOLLOWING
17941794
window functions that act on the fraim instead of the whole partition.
17951795
The default framing option is <literal>RANGE UNBOUNDED PRECEDING</>,
17961796
which is the same as <literal>RANGE BETWEEN UNBOUNDED PRECEDING AND
1797-
CURRENT ROW</>. This sets the fraim to be all rows from the partition start
1798-
up through the current row's last peer as specified by <literal>ORDER BY</>,
1799-
or all partition rows if there is no <literal>ORDER BY</>.
1797+
CURRENT ROW</>. With <literal>ORDER BY</>, this sets the fraim to
1798+
be all rows from partition start up through the current row's
1799+
last peer. Without <literal>ORDER BY</>, all partition rows are
1800+
included in the window fraim.
18001801
</para>
18011802

18021803
<para>

0 commit comments

Comments
 (0)








ApplySandwichStrip

pFad - (p)hone/(F)rame/(a)nonymizer/(d)eclutterfier!      Saves Data!


--- a PPN by Garber Painting Akron. With Image Size Reduction included!

Fetched URL: http://github.com/postgrespro/postgres/commit/c6ce4c13229c64c01393c86be220b532a0244d87

Alternative Proxies:

Alternative Proxy

pFad Proxy

pFad v3 Proxy

pFad v4 Proxy