Implement operators for checking if the range contains a multirange
Alexander Korotkov <akorotkov@postgresql.org>
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.
Files
| Path | Change | +/− |
|---|---|---|
| doc/src/sgml/func.sgml | modified | +14 −0 |
| src/backend/utils/adt/multirangetypes.c | modified | +60 −0 |
| src/backend/utils/adt/multirangetypes_selfuncs.c | modified | +5 −1 |
| src/include/catalog/catversion.h | modified | +1 −1 |
| src/include/catalog/pg_operator.dat | modified | +12 −0 |
| src/include/catalog/pg_proc.dat | modified | +6 −0 |
| src/include/utils/multirangetypes.h | modified | +3 −1 |
| src/test/regress/expected/multirangetypes.out | modified | +240 −0 |
| src/test/regress/sql/multirangetypes.sql | modified | +40 −0 |