OSDN Git Service

Support window functions a la SQL:2008.
authorTom Lane <tgl@sss.pgh.pa.us>
Sun, 28 Dec 2008 18:54:01 +0000 (18:54 +0000)
committerTom Lane <tgl@sss.pgh.pa.us>
Sun, 28 Dec 2008 18:54:01 +0000 (18:54 +0000)
commit95b07bc7f5010233f52f9d11da74e2e5b653b0a7
tree48f5858bf4eca1bfb316ef02bb959ca85f568e0a
parent38e9348282e9d078487147ba8a85aebec54e3a08
Support window functions a la SQL:2008.

Hitoshi Harada, with some kibitzing from Heikki and Tom.
92 files changed:
contrib/tsearch2/tsearch2.c
doc/src/sgml/advanced.sgml
doc/src/sgml/errcodes.sgml
doc/src/sgml/func.sgml
doc/src/sgml/queries.sgml
doc/src/sgml/query.sgml
doc/src/sgml/ref/select.sgml
doc/src/sgml/ref/select_into.sgml
doc/src/sgml/syntax.sgml
doc/src/sgml/xaggr.sgml
src/backend/catalog/dependency.c
src/backend/catalog/heap.c
src/backend/catalog/pg_proc.c
src/backend/commands/explain.c
src/backend/commands/functioncmds.c
src/backend/commands/prepare.c
src/backend/commands/tablecmds.c
src/backend/commands/typecmds.c
src/backend/executor/Makefile
src/backend/executor/execAmi.c
src/backend/executor/execProcnode.c
src/backend/executor/execQual.c
src/backend/executor/nodeWindowAgg.c [new file with mode: 0644]
src/backend/nodes/copyfuncs.c
src/backend/nodes/equalfuncs.c
src/backend/nodes/nodeFuncs.c
src/backend/nodes/outfuncs.c
src/backend/nodes/readfuncs.c
src/backend/optimizer/path/allpaths.c
src/backend/optimizer/path/costsize.c
src/backend/optimizer/path/equivclass.c
src/backend/optimizer/plan/createplan.c
src/backend/optimizer/plan/planagg.c
src/backend/optimizer/plan/planmain.c
src/backend/optimizer/plan/planner.c
src/backend/optimizer/plan/setrefs.c
src/backend/optimizer/plan/subselect.c
src/backend/optimizer/prep/prepjointree.c
src/backend/optimizer/prep/prepunion.c
src/backend/optimizer/util/clauses.c
src/backend/optimizer/util/tlist.c
src/backend/parser/analyze.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/parser/parse_coerce.c
src/backend/parser/parse_expr.c
src/backend/parser/parse_func.c
src/backend/parser/parse_type.c
src/backend/parser/parse_utilcmd.c
src/backend/rewrite/rewriteManip.c
src/backend/utils/adt/Makefile
src/backend/utils/adt/array_userfuncs.c
src/backend/utils/adt/arrayfuncs.c
src/backend/utils/adt/float.c
src/backend/utils/adt/int8.c
src/backend/utils/adt/numeric.c
src/backend/utils/adt/ruleutils.c
src/backend/utils/adt/windowfuncs.c [new file with mode: 0644]
src/backend/utils/fmgr/fmgr.c
src/backend/utils/sort/tuplestore.c
src/include/catalog/catversion.h
src/include/catalog/pg_proc.h
src/include/executor/nodeWindowAgg.h [new file with mode: 0644]
src/include/fmgr.h
src/include/nodes/execnodes.h
src/include/nodes/nodes.h
src/include/nodes/parsenodes.h
src/include/nodes/plannodes.h
src/include/nodes/primnodes.h
src/include/nodes/relation.h
src/include/optimizer/clauses.h
src/include/optimizer/cost.h
src/include/optimizer/planmain.h
src/include/optimizer/tlist.h
src/include/parser/parse_agg.h
src/include/parser/parse_clause.h
src/include/parser/parse_func.h
src/include/parser/parse_node.h
src/include/rewrite/rewriteManip.h
src/include/utils/array.h
src/include/utils/builtins.h
src/include/utils/errcodes.h
src/include/utils/tuplestore.h
src/include/windowapi.h [new file with mode: 0644]
src/pl/plpgsql/src/plerrcodes.h
src/test/regress/expected/window.out [new file with mode: 0644]
src/test/regress/expected/with.out
src/test/regress/parallel_schedule
src/test/regress/serial_schedule
src/test/regress/sql/window.sql [new file with mode: 0644]