Thread: pgsql: Implement operators for checking if the range contains a multira
pgsql: Implement operators for checking if the range contains a multira
From
Alexander Korotkov
Date:
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(-)