pgsql: Add support of multirange matching to the existing range GiST in
| От | Alexander Korotkov |
|---|---|
| Тема | pgsql: Add support of multirange matching to the existing range GiST in |
| Дата | |
| Msg-id | E1kuLsE-0000q2-QV@gemulon.postgresql.org обсуждение исходный текст |
| Ответы |
Re: pgsql: Add support of multirange matching to the existing range GiST in
|
| Список | pgsql-committers |
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(-)
В списке pgsql-committers по дате отправления: