The default range specification is:
RANGE BETWEEN UNBOUNDED PRECEDING AND CURRENT ROW
It seems like a common second choice is to want:
RANGE BETWEEN UNBOUNDED PRECEDING AND UNBOUNDED FOLLOWING
Why did they have to make something so common take 49 characters that, for seldom-using users, is nearly impossible to remember?
The following would seem to suffice:
{ RANGE | ROWS } ALL
I'd be happy to use non-portable syntax here...
As an aside, I'd vote to add the entire WINDOW syntax specification to the Synopsis. The main parameters section can remain as-is in order to aid in reading comprehension - but having to search out the parameters area just to remind oneself of the extremely verbose syntax is a bit annoying. All of the other sections are represented in both the main synopsis and the parameters in this manner and I think WINDOW doesn't warrant an exception (especially vis-a-via both the from_item and grouping_element specifications).
David J.
