pgsql: Add support of multirange matching to the existing range GiST in

From: Alexander Korotkov <akorotkov(at)postgresql(dot)org>
To: pgsql-committers(at)lists(dot)postgresql(dot)org
Subject: pgsql: Add support of multirange matching to the existing range GiST in
Date: 2020-12-29 20:45:42
Message-ID: E1kuLsE-0000q2-QV@gemulon.postgresql.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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(-)

Responses

Browse pgsql-committers by date

  From Date Subject
Next Message Alexander Korotkov 2020-12-29 20:53:14 Re: pgsql: Add support of multirange matching to the existing range GiST in
Previous Message Michael Paquier 2020-12-29 09:21:31 pgsql: doc: Improve some grammar and sentences