git.postgresql.org Git - postgresql.git/commit

git projects / postgresql.git / commit
? search:
summary | shortlog | log | commit | commitdiff | tree
(parent: a5348fa) | patch
Extend the set of frame options supported for window functions.
2010年2月12日 17:33:21 +0000 (17:33 +0000)
2010年2月12日 17:33:21 +0000 (17:33 +0000)
commit ec4be2ee6827b6bd85e0813c7a8993cfbb0e6fa7
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
28 files changed:
doc/src/sgml/func.sgml diff | blob | blame | history
doc/src/sgml/ref/select.sgml diff | blob | blame | history
doc/src/sgml/syntax.sgml diff | blob | blame | history
src/backend/executor/nodeAgg.c diff | blob | blame | history
src/backend/executor/nodeWindowAgg.c diff | blob | blame | history
src/backend/nodes/copyfuncs.c diff | blob | blame | history
src/backend/nodes/equalfuncs.c diff | blob | blame | history
src/backend/nodes/nodeFuncs.c diff | blob | blame | history
src/backend/nodes/outfuncs.c diff | blob | blame | history
src/backend/nodes/readfuncs.c diff | blob | blame | history
src/backend/optimizer/plan/createplan.c diff | blob | blame | history
src/backend/optimizer/plan/planner.c diff | blob | blame | history
src/backend/optimizer/plan/setrefs.c diff | blob | blame | history
src/backend/optimizer/plan/subselect.c diff | blob | blame | history
src/backend/parser/gram.y diff | blob | blame | history
src/backend/parser/parse_agg.c diff | blob | blame | history
src/backend/parser/parse_clause.c diff | blob | blame | history
src/backend/utils/adt/ruleutils.c diff | blob | blame | history
src/include/catalog/catversion.h diff | blob | blame | history
src/include/nodes/execnodes.h diff | blob | blame | history
src/include/nodes/parsenodes.h diff | blob | blame | history
src/include/nodes/plannodes.h diff | blob | blame | history
src/include/optimizer/planmain.h diff | blob | blame | history
src/include/parser/kwlist.h diff | blob | blame | history
src/test/regress/expected/window.out diff | blob | blame | history
src/test/regress/parallel_schedule diff | blob | blame | history
src/test/regress/serial_schedule diff | blob | blame | history
src/test/regress/sql/window.sql diff | blob | blame | history
This is the main PostgreSQL git repository.
RSS Atom

AltStyle によって変換されたページ (->オリジナル) /