0002-Fix-small-inconsistencies-in-catalog-definition-of--.patch

application/octet-stream

Filename: 0002-Fix-small-inconsistencies-in-catalog-definition-of--.patch
Type: application/octet-stream
Part: 0
Message: Re: unnesting multirange data types

Patch

Format: format-patch
Series: patch 0002
Subject: Fix small inconsistencies in catalog definition of multirange operators
File+
src/include/catalog/pg_operator.dat 3 3
From f19a95d9d79153e9e90d38aac8a0306a3e535c1a Mon Sep 17 00:00:00 2001
From: Alexander Korotkov <akorotkov@postgresql.org>
Date: Sat, 26 Jun 2021 21:50:20 +0300
Subject: [PATCH 2/2] Fix small inconsistencies in catalog definition of
 multirange operators

Requires catversion bump.
---
 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',
-- 
2.24.3 (Apple Git-128)