pgsql: Support range data types. - Mailing list pgsql-committers
| From | Heikki Linnakangas |
|---|---|
| Subject | pgsql: Support range data types. |
| Date | |
| Msg-id | E1RLvuW-000340-AP@gemulon.postgresql.org Whole thread Raw |
| List | 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(-)
pgsql-committers by date: