OSDN Git Service

Add aggsortop column to pg_aggregate, so that MIN/MAX optimization can
authorTom Lane <tgl@sss.pgh.pa.us>
Tue, 12 Apr 2005 04:26:34 +0000 (04:26 +0000)
committerTom Lane <tgl@sss.pgh.pa.us>
Tue, 12 Apr 2005 04:26:34 +0000 (04:26 +0000)
commit2e7a68896bfa84b28cd57e23e141aa9c899275c7
tree11d360de8f7aab0d5c3345a45e61169c40f83538
parent3803f243790466722cb6cd26118f48629261cb58
Add aggsortop column to pg_aggregate, so that MIN/MAX optimization can
be supported for all datatypes.  Add CREATE AGGREGATE and pg_dump support
too.  Add specialized min/max aggregates for bpchar, instead of depending
on text's min/max, because otherwise the possible use of bpchar indexes
cannot be recognized.
initdb forced because of catalog changes.
15 files changed:
doc/src/sgml/catalogs.sgml
doc/src/sgml/ref/create_aggregate.sgml
src/backend/catalog/pg_aggregate.c
src/backend/commands/aggregatecmds.c
src/backend/optimizer/plan/planagg.c
src/backend/utils/adt/varchar.c
src/bin/pg_dump/pg_dump.c
src/include/catalog/catversion.h
src/include/catalog/pg_aggregate.h
src/include/catalog/pg_proc.h
src/include/utils/builtins.h
src/test/regress/expected/oidjoins.out
src/test/regress/expected/opr_sanity.out
src/test/regress/sql/oidjoins.sql
src/test/regress/sql/opr_sanity.sql