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)