Add support of multirange matching to the existing range GiST indexes
authorAlexander Korotkov <akorotkov@postgresql.org>
Tue, 29 Dec 2020 20:36:43 +0000 (23:36 +0300)
committerAlexander Korotkov <akorotkov@postgresql.org>
Tue, 29 Dec 2020 20:36:43 +0000 (23:36 +0300)
commitdb6335b5b1d6654b0e3104f36817800d127c1c91
tree831be345c2a6197e3264f178ffbaae25f34e546c
parentd1d61a8b23b604faf797695eeacaa5da4fe64762
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.
15 files changed:
doc/src/sgml/gist.sgml
doc/src/sgml/rangetypes.sgml
src/backend/utils/adt/multirangetypes.c
src/backend/utils/adt/rangetypes_gist.c
src/include/catalog/catversion.h
src/include/catalog/pg_amop.dat
src/include/catalog/pg_amproc.dat
src/include/catalog/pg_opclass.dat
src/include/catalog/pg_opfamily.dat
src/include/catalog/pg_proc.dat
src/include/utils/multirangetypes.h
src/test/regress/expected/multirangetypes.out
src/test/regress/expected/rangetypes.out
src/test/regress/sql/multirangetypes.sql
src/test/regress/sql/rangetypes.sql