pgsql: Implement operators for checking if the range contains a multira - Mailing list pgsql-committers

From Alexander Korotkov
Subject pgsql: Implement operators for checking if the range contains a multira
Date
Msg-id E1kuLsE-0000pw-Pc@gemulon.postgresql.org
Whole thread Raw
List pgsql-committers
Implement operators for checking if the range contains a multirange

We have operators for checking if the multirange contains a range but don't
have the opposite.  This commit improves completeness of the operator set by
adding two new operators: @> (anyrange,anymultirange) and
<@(anymultirange,anyrange).

Catversion is bumped.

Branch
------
master

Details
-------
https://git.postgresql.org/pg/commitdiff/4d7684cc754f312aee468abb83ca4f7da94b30a3

Modified Files
--------------
doc/src/sgml/func.sgml                           |  14 ++
src/backend/utils/adt/multirangetypes.c          |  60 ++++++
src/backend/utils/adt/multirangetypes_selfuncs.c |   6 +-
src/include/catalog/catversion.h                 |   2 +-
src/include/catalog/pg_operator.dat              |  12 ++
src/include/catalog/pg_proc.dat                  |   6 +
src/include/utils/multirangetypes.h              |   4 +-
src/test/regress/expected/multirangetypes.out    | 240 +++++++++++++++++++++++
src/test/regress/sql/multirangetypes.sql         |  40 ++++
9 files changed, 381 insertions(+), 3 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