Add some basic support for window frame clauses to the window-functions
authorTom Lane <tgl@sss.pgh.pa.us>
Wed, 31 Dec 2008 00:08:39 +0000 (00:08 +0000)
committerTom Lane <tgl@sss.pgh.pa.us>
Wed, 31 Dec 2008 00:08:39 +0000 (00:08 +0000)
commit8e8854daa2b4b3ef9e3fc1a56c79608a70018058
treea6c4cf4b43acc764a38071843c10dc3edb3ca32e
parent0fb9be7acfb31ba38c1bbdd7883d5d03f6e261e5
Add some basic support for window frame clauses to the window-functions
patch.  This includes the ability to force the frame to cover the whole
partition, and the ability to make the frame end exactly on the current row
rather than its last ORDER BY peer.  Supporting any more of the full SQL
frame-clause syntax will require nontrivial hacking on the window aggregate
code, so it'll have to wait for 8.5 or beyond.
24 files changed:
doc/src/sgml/advanced.sgml
doc/src/sgml/func.sgml
doc/src/sgml/queries.sgml
doc/src/sgml/ref/select.sgml
doc/src/sgml/syntax.sgml
src/backend/executor/nodeWindowAgg.c
src/backend/nodes/copyfuncs.c
src/backend/nodes/equalfuncs.c
src/backend/nodes/outfuncs.c
src/backend/nodes/readfuncs.c
src/backend/optimizer/plan/createplan.c
src/backend/optimizer/plan/planner.c
src/backend/parser/gram.y
src/backend/parser/keywords.c
src/backend/parser/parse_agg.c
src/backend/parser/parse_clause.c
src/backend/utils/adt/ruleutils.c
src/include/catalog/catversion.h
src/include/nodes/execnodes.h
src/include/nodes/parsenodes.h
src/include/nodes/plannodes.h
src/include/optimizer/planmain.h
src/test/regress/expected/window.out
src/test/regress/sql/window.sql