pgsql: Add support of multirange matching to the existing range GiST in - Mailing list pgsql-committers

From Alexander Korotkov
Subject pgsql: Add support of multirange matching to the existing range GiST in
Date
Msg-id E1kuLsE-0000q2-QV@gemulon.postgresql.org
Whole thread Raw
Responses Re: pgsql: Add support of multirange matching to the existing range GiST in  (Alexander Korotkov <aekorotkov@gmail.com>)
List 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 by date:

Previous
From: Michael Paquier
Date:
Subject: pgsql: doc: Improve some grammar and sentences
Next
From: Alexander Korotkov
Date:
Subject: Re: pgsql: Add support of multirange matching to the existing range GiST in