Implement operators for checking if the range contains a multirange
authorAlexander Korotkov <akorotkov@postgresql.org>
Tue, 29 Dec 2020 20:35:33 +0000 (23:35 +0300)
committerAlexander Korotkov <akorotkov@postgresql.org>
Tue, 29 Dec 2020 20:35:33 +0000 (23:35 +0300)
commit4d7684cc754f312aee468abb83ca4f7da94b30a3
tree7fea580c6c30561d5a50c2a5d14b612a7b4e6626
parenta5b81b6f0006ea0b502780ce7f73d295a225842c
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.
doc/src/sgml/func.sgml
src/backend/utils/adt/multirangetypes.c
src/backend/utils/adt/multirangetypes_selfuncs.c
src/include/catalog/catversion.h
src/include/catalog/pg_operator.dat
src/include/catalog/pg_proc.dat
src/include/utils/multirangetypes.h
src/test/regress/expected/multirangetypes.out
src/test/regress/sql/multirangetypes.sql