Add support of multirange matching to the existing range GiST indexes
6df7a9698b has introduced a set of operators between ranges and multiranges.
Existing GiST indexes for ranges could easily support majority of them.
This commit adds support for new operators to the existing range GiST indexes.
New operators resides the same strategy numbers as existing ones. Appropriate
check function is determined using the subtype.
Catversion is bumped.
Branch
------
master
Details
-------
https://git.postgresql.org/pg/commitdiff/db6335b5b1d6654b0e3104f36817800d127c1c91
Modified Files
--------------
doc/src/sgml/gist.sgml | 35 ++-
doc/src/sgml/rangetypes.sgml | 21 +-
src/backend/utils/adt/multirangetypes.c | 21 ++
src/backend/utils/adt/rangetypes_gist.c | 393 +++++++++++++++++++++-----
src/include/catalog/catversion.h | 2 +-
src/include/catalog/pg_amop.dat | 80 ++++++
src/include/catalog/pg_amproc.dat | 18 ++
src/include/catalog/pg_opclass.dat | 2 +
src/include/catalog/pg_opfamily.dat | 2 +
src/include/catalog/pg_proc.dat | 8 +
src/include/utils/multirangetypes.h | 2 +
src/test/regress/expected/multirangetypes.out | 257 +++++++++++++++++
src/test/regress/expected/rangetypes.out | 162 +++++++++++
src/test/regress/sql/multirangetypes.sql | 63 +++++
src/test/regress/sql/rangetypes.sql | 27 ++
15 files changed, 1024 insertions(+), 69 deletions(-)