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

git projects / postgresql.git / commit
? search:
summary | shortlog | log | commit | commitdiff | tree
(parent: 139f19c) | patch
Revise aggregate functions per earlier discussions in pghackers.
2000年7月17日 03:05:41 +0000 (03:05 +0000)
2000年7月17日 03:05:41 +0000 (03:05 +0000)
commit bec98a31c55a4f799b398d01541e68d7c086bb81
Revise aggregate functions per earlier discussions in pghackers.
There's now only one transition value and transition function.
NULL handling in aggregates is a lot cleaner. Also, use Numeric
accumulators instead of integer accumulators for sum/avg on integer
datatypes --- this avoids overflow at the cost of being a little slower.
Implement VARIANCE() and STDDEV() aggregates in the standard backend.

Also, enable new LIKE selectivity estimators by default. Unrelated
change, but as long as I had to force initdb anyway...
55 files changed:
doc/src/sgml/catalogs.sgml diff | blob | blame | history
doc/src/sgml/ref/create_aggregate.sgml diff | blob | blame | history
doc/src/sgml/ref/drop_aggregate.sgml diff | blob | blame | history
doc/src/sgml/xaggr.sgml diff | blob | blame | history
src/backend/catalog/pg_aggregate.c diff | blob | blame | history
src/backend/commands/define.c diff | blob | blame | history
src/backend/commands/user.c diff | blob | blame | history
src/backend/executor/execQual.c diff | blob | blame | history
src/backend/executor/execScan.c diff | blob | blame | history
src/backend/executor/nodeAgg.c diff | blob | blame | history
src/backend/executor/nodeHash.c diff | blob | blame | history
src/backend/executor/nodeHashjoin.c diff | blob | blame | history
src/backend/executor/nodeNestloop.c diff | blob | blame | history
src/backend/executor/nodeResult.c diff | blob | blame | history
src/backend/libpq/be-fsstubs.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/outfuncs.c diff | blob | blame | history
src/backend/nodes/readfuncs.c diff | blob | blame | history
src/backend/parser/parse_agg.c diff | blob | blame | history
src/backend/postmaster/postmaster.c diff | blob | blame | history
src/backend/storage/lmgr/lock.c diff | blob | blame | history
src/backend/storage/smgr/md.c diff | blob | blame | history
src/backend/tcop/postgres.c diff | blob | blame | history
src/backend/tcop/pquery.c diff | blob | blame | history
src/backend/utils/adt/arrayfuncs.c diff | blob | blame | history
src/backend/utils/adt/float.c diff | blob | blame | history
src/backend/utils/adt/int.c diff | blob | blame | history
src/backend/utils/adt/numeric.c diff | blob | blame | history
src/backend/utils/adt/timestamp.c diff | blob | blame | history
src/bin/pg_dump/pg_dump.c diff | blob | blame | history
src/bin/pg_dump/pg_dump.h diff | blob | blame | history
src/include/c.h diff | blob | blame | history
src/include/catalog/catversion.h diff | blob | blame | history
src/include/catalog/pg_aggregate.h diff | blob | blame | history
src/include/catalog/pg_operator.h diff | blob | blame | history
src/include/catalog/pg_proc.h diff | blob | blame | history
src/include/nodes/primnodes.h diff | blob | blame | history
src/include/storage/lock.h diff | blob | blame | history
src/include/utils/array.h diff | blob | blame | history
src/include/utils/builtins.h diff | blob | blame | history
src/include/utils/numeric.h diff | blob | blame | history
src/include/utils/timestamp.h diff | blob | blame | history
src/pl/tcl/test/test_setup.sql diff | blob | blame | history
src/test/regress/expected/aggregates.out diff | blob | blame | history
src/test/regress/expected/create_aggregate.out diff | blob | blame | history
src/test/regress/expected/errors.out diff | blob | blame | history
src/test/regress/expected/oidjoins.out diff | blob | blame | history
src/test/regress/expected/opr_sanity.out diff | blob | blame | history
src/test/regress/sql/aggregates.sql diff | blob | blame | history
src/test/regress/sql/create_aggregate.sql diff | blob | blame | history
src/test/regress/sql/errors.sql diff | blob | blame | history
src/test/regress/sql/oidjoins.sql diff | blob | blame | history
src/test/regress/sql/opr_sanity.sql diff | blob | blame | history
src/tutorial/complex.source diff | blob | blame | history
This is the main PostgreSQL git repository.
RSS Atom

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