pgsql: Support range data types.

Support range data types.

Selectivity estimation functions are missing for some range type operators,
which is a TODO.

Jeff Davis

Branch
------
master

Details
-------
http://git.postgresql.org/pg/commitdiff/4429f6a9e3e12bb4af6e3677fbc78cd80f160252

Modified Files
--------------
doc/src/sgml/catalogs.sgml | 77 +
doc/src/sgml/datatype.sgml | 16 +-
doc/src/sgml/extend.sgml | 22 +-
doc/src/sgml/filelist.sgml | 1 +
doc/src/sgml/func.sgml | 304 +++
doc/src/sgml/plpgsql.sgml | 6 +-
doc/src/sgml/rangetypes.sgml | 373 ++++
doc/src/sgml/ref/create_type.sgml | 61 +-
doc/src/sgml/xfunc.sgml | 6 +-
src/backend/catalog/Makefile | 6 +-
src/backend/catalog/pg_proc.c | 63 +-
src/backend/catalog/pg_range.c | 136 ++
src/backend/commands/typecmds.c | 445 +++++-
src/backend/executor/functions.c | 1 +
src/backend/nodes/copyfuncs.c | 14 +
src/backend/nodes/equalfuncs.c | 12 +
src/backend/parser/gram.y | 7 +
src/backend/parser/parse_coerce.c | 180 ++-
src/backend/tcop/utility.c | 13 +
src/backend/utils/adt/Makefile | 4 +-
src/backend/utils/adt/date.c | 1 -
src/backend/utils/adt/pseudotypes.c | 24 +
src/backend/utils/adt/rangetypes.c | 2153 ++++++++++++++++++++++
src/backend/utils/adt/rangetypes_gist.c | 587 ++++++
src/backend/utils/cache/lsyscache.c | 30 +
src/backend/utils/cache/syscache.c | 12 +
src/backend/utils/fmgr/funcapi.c | 115 +-
src/bin/pg_dump/pg_dump.c | 184 ++-
src/include/catalog/catversion.h | 3 +-
src/include/catalog/indexing.h | 3 +
src/include/catalog/pg_amop.h | 30 +
src/include/catalog/pg_amproc.h | 9 +
src/include/catalog/pg_opclass.h | 3 +
src/include/catalog/pg_operator.h | 39 +
src/include/catalog/pg_opfamily.h | 3 +
src/include/catalog/pg_proc.h | 147 ++
src/include/catalog/pg_range.h | 84 +
src/include/catalog/pg_type.h | 29 +-
src/include/commands/typecmds.h | 1 +
src/include/nodes/nodes.h | 1 +
src/include/nodes/parsenodes.h | 11 +
src/include/utils/lsyscache.h | 2 +
src/include/utils/rangetypes.h | 159 ++
src/include/utils/syscache.h | 1 +
src/pl/plpgsql/src/pl_comp.c | 10 +-
src/test/regress/expected/collate.linux.utf8.out | 17 +
src/test/regress/expected/opr_sanity.out | 37 +-
src/test/regress/expected/plpgsql.out | 14 +
src/test/regress/expected/rangetypes.out | 951 ++++++++++
src/test/regress/expected/sanity_check.out | 3 +-
src/test/regress/expected/type_sanity.out | 2 +-
src/test/regress/parallel_schedule | 2 +-
src/test/regress/serial_schedule | 1 +
src/test/regress/sql/collate.linux.utf8.sql | 11 +
src/test/regress/sql/opr_sanity.sql | 12 +-
src/test/regress/sql/plpgsql.sql | 10 +
src/test/regress/sql/rangetypes.sql | 371 ++++
src/test/regress/sql/type_sanity.sql | 2 +-
58 files changed, 6718 insertions(+), 103 deletions(-)