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

]> git.ipfire.org Git - thirdparty/postgresql.git/commit

projects / thirdparty / postgresql.git / commit

author	Tom Lane <tgl@sss.pgh.pa.us>
	Fri, 12 Feb 2010 17:33:21 +0000 (17:33 +0000)
committer	Tom Lane <tgl@sss.pgh.pa.us>
	Fri, 12 Feb 2010 17:33:21 +0000 (17:33 +0000)
commit	ec4be2ee6827b6bd85e0813c7a8993cfbb0e6fa7
tree	f4f98eb0f5ff45dbcd23778a1c683a1f597431b7	tree \| snapshot
parent	a5348fafd182d5b84c89b43af3746711ce28f319	commit \| diff

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

Mirror of https://git.postgresql.org/git/postgresql.git

RSS Atom