Add support of multirange matching to the existing range GiST indexes
Alexander Korotkov <akorotkov@postgresql.org>
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.
Files
| Path | Change | +/− |
|---|---|---|
| doc/src/sgml/gist.sgml | modified | +33 −2 |
| doc/src/sgml/rangetypes.sgml | modified | +18 −3 |
| src/backend/utils/adt/multirangetypes.c | modified | +21 −0 |
| src/backend/utils/adt/rangetypes_gist.c | modified | +330 −63 |
| src/include/catalog/catversion.h | modified | +1 −1 |
| src/include/catalog/pg_amop.dat | modified | +80 −0 |
| src/include/catalog/pg_amproc.dat | modified | +18 −0 |
| src/include/catalog/pg_opclass.dat | modified | +2 −0 |
| src/include/catalog/pg_opfamily.dat | modified | +2 −0 |
| src/include/catalog/pg_proc.dat | modified | +8 −0 |
| src/include/utils/multirangetypes.h | modified | +2 −0 |
| src/test/regress/expected/multirangetypes.out | modified | +257 −0 |
| src/test/regress/expected/rangetypes.out | modified | +162 −0 |
| src/test/regress/sql/multirangetypes.sql | modified | +63 −0 |
| src/test/regress/sql/rangetypes.sql | modified | +27 −0 |