]> granicus.if.org Git - postgresql/commit
Implement the FILTER clause for aggregate function calls.
authorNoah Misch <noah@leadboat.com>
Wed, 17 Jul 2013 00:15:36 +0000 (20:15 -0400)
committerNoah Misch <noah@leadboat.com>
Wed, 17 Jul 2013 00:15:36 +0000 (20:15 -0400)
commitb560ec1b0d7b910ce13edc51ffaafaca72136e3b
treeae5d80c94681788fd214efe6d61425089850781e
parent7a8e9f298e7b8158296e1ea72ca8987323c10edf
Implement the FILTER clause for aggregate function calls.

This is SQL-standard with a few extensions, namely support for
subqueries and outer references in clause expressions.

catversion bump due to change in Aggref and WindowFunc.

David Fetter, reviewed by Dean Rasheed.
35 files changed:
contrib/pg_stat_statements/pg_stat_statements.c
doc/src/sgml/keywords.sgml
doc/src/sgml/ref/select.sgml
doc/src/sgml/syntax.sgml
src/backend/executor/execQual.c
src/backend/executor/execUtils.c
src/backend/executor/functions.c
src/backend/executor/nodeAgg.c
src/backend/executor/nodeWindowAgg.c
src/backend/nodes/copyfuncs.c
src/backend/nodes/equalfuncs.c
src/backend/nodes/makefuncs.c
src/backend/nodes/nodeFuncs.c
src/backend/nodes/outfuncs.c
src/backend/nodes/readfuncs.c
src/backend/optimizer/path/costsize.c
src/backend/optimizer/plan/planagg.c
src/backend/optimizer/util/clauses.c
src/backend/parser/gram.y
src/backend/parser/parse_agg.c
src/backend/parser/parse_collate.c
src/backend/parser/parse_expr.c
src/backend/parser/parse_func.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/primnodes.h
src/include/parser/kwlist.h
src/include/parser/parse_func.h
src/include/parser/parse_node.h
src/test/regress/expected/aggregates.out
src/test/regress/expected/window.out
src/test/regress/sql/aggregates.sql
src/test/regress/sql/window.sql