Extend the set of frame options supported for window functions.

Tom Lane <tgl@sss.pgh.pa.us>

Commit: ec4be2ee6827b6bd85e0813c7a8993cfbb0e6fa7

Author: Tom Lane <tgl@sss.pgh.pa.us>

Date: 2010-02-12T17:33:21Z

Extend the set of frame options supported for window functions.

This patch allows the frame to start from CURRENT ROW (in either RANGE or
ROWS mode), and it also adds support for ROWS n PRECEDING and ROWS n FOLLOWING
start and end points.  (RANGE value PRECEDING/FOLLOWING isn't there yet ---
the grammar works, but that's all.)

Hitoshi Harada, reviewed by Pavel Stehule

Files

Path	Change	+/−
doc/src/sgml/func.sgml	modified	+12 −10
doc/src/sgml/ref/select.sgml	modified	+59 −20
doc/src/sgml/syntax.sgml	modified	+41 −18
src/backend/executor/nodeAgg.c	modified	+2 −2
src/backend/executor/nodeWindowAgg.c	modified	+526 −122
src/backend/nodes/copyfuncs.c	modified	+7 −1
src/backend/nodes/equalfuncs.c	modified	+5 −1
src/backend/nodes/nodeFuncs.c	modified	+11 −1
src/backend/nodes/outfuncs.c	modified	+7 −1
src/backend/nodes/readfuncs.c	modified	+3 −1
src/backend/optimizer/plan/createplan.c	modified	+5 −2
src/backend/optimizer/plan/planner.c	modified	+18 −2
src/backend/optimizer/plan/setrefs.c	modified	+18 −2
src/backend/optimizer/plan/subselect.c	modified	+8 −2
src/backend/parser/gram.y	modified	+113 −28
src/backend/parser/parse_agg.c	modified	+5 −2
src/backend/parser/parse_clause.c	modified	+81 −12
src/backend/utils/adt/ruleutils.c	modified	+21 −1
src/include/catalog/catversion.h	modified	+2 −2
src/include/nodes/execnodes.h	modified	+20 −7
src/include/nodes/parsenodes.h	modified	+14 −1
src/include/nodes/plannodes.h	modified	+3 −1
src/include/optimizer/planmain.h	modified	+3 −2
src/include/parser/kwlist.h	modified	+2 −2
src/test/regress/expected/window.out	modified	+187 −0
src/test/regress/parallel_schedule	modified	+4 −3
src/test/regress/serial_schedule	modified	+2 −2
src/test/regress/sql/window.sql	modified	+52 −0