pgsql: Support range data types.

From: Heikki Linnakangas <heikki(dot)linnakangas(at)iki(dot)fi>
To: pgsql-committers(at)postgresql(dot)org
Subject: pgsql: Support range data types.
Date: 2011-11-03 11:56:44
Message-ID: E1RLvuW-000340-AP@gemulon.postgresql.org
Views: Raw Message | Whole Thread | Download mbox
Thread:
Lists: pgsql-committers

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(-)

Browse pgsql-committers by date

  From Date Subject
Next Message Magnus Hagander 2011-11-03 14:39:31 pgsql: Pre-pad WAL files when streaming transaction log
Previous Message Robert Haas 2011-11-03 11:33:18 Re: Re: [COMMITTERS] pgsql: Reduce checkpoints and WAL traffic on low activity database serv