postgres.git / summary / log / commit / refs

commit    768ea9bcf98120eef01a6deea9c5c6997b153ab1
Author:   Alexander Korotkov <akorotkov@postgresql.org>
Date:     Thu Jul 15 11:18:19 2021 +0000
First released in: 15.0, 14.0

    Fix small inconsistencies in catalog definition of multirange operators
    
    This commit fixes the description of a couple of multirange operators and
    oprjoin for another multirange operator.  The change of oprjoin is more
    cosmetic since both old and new functions return the same constant.
    
    These cosmetic changes don't worth catalog incompatibility between 14beta2
    and 14beta3.  So, catversion isn't bumped.
    
    Discussion: https://postgr.es/m/CAPpHfdv9OZEuZDqOQoUKpXhq%3Dmc-qa4gKCPmcgG5Vvesu7%3Ds1w%40mail.gmail.com
    Backpatch-throgh: 14


 src/include/catalog/pg_operator.dat | 6 +++---
 1 file changed, 3 insertions(+), 3 deletions(-)

diff --git a/src/include/catalog/pg_operator.dat b/src/include/catalog/pg_operator.dat
index ec1615cccca..89c73acd680 100644
--- a/src/include/catalog/pg_operator.dat
+++ b/src/include/catalog/pg_operator.dat
@@ -3320,13 +3320,13 @@
   oprcode => 'range_overlaps_multirange', oprrest => 'multirangesel',
   oprjoin => 'areajoinsel' },
 { oid => '2867', oid_symbol => 'OID_MULTIRANGE_OVERLAPS_RANGE_OP',
-  descr => 'contains',
+  descr => 'overlaps',
   oprname => '&&', oprleft => 'anymultirange', oprright => 'anyrange',
   oprresult => 'bool', oprcom => '&&(anyrange,anymultirange)',
   oprcode => 'multirange_overlaps_range', oprrest => 'multirangesel',
   oprjoin => 'areajoinsel' },
 { oid => '2868', oid_symbol => 'OID_MULTIRANGE_OVERLAPS_MULTIRANGE_OP',
-  descr => 'contains',
+  descr => 'overlaps',
   oprname => '&&', oprleft => 'anymultirange', oprright => 'anymultirange',
   oprresult => 'bool', oprcom => '&&(anymultirange,anymultirange)',
   oprcode => 'multirange_overlaps_multirange', oprrest => 'multirangesel',
@@ -3393,7 +3393,7 @@
   descr => 'overlaps or is left of',
   oprname => '&<', oprleft => 'anymultirange', oprright => 'anymultirange',
   oprresult => 'bool', oprcode => 'multirange_overleft_multirange',
-  oprrest => 'multirangesel', oprjoin => 'scalargtjoinsel' },
+  oprrest => 'multirangesel', oprjoin => 'scalarltjoinsel' },
 { oid => '3585', oid_symbol => 'OID_RANGE_OVERLAPS_RIGHT_MULTIRANGE_OP',
   descr => 'overlaps or is right of',
   oprname => '&>', oprleft => 'anyrange', oprright => 'anymultirange',


[parent: 2bfb50b3df11]