summaryrefslogtreecommitdiff
path: root/contrib/intarray
diff options
context:
space:
mode:
authorTom Lane2004-01-08 23:40:27 +0000
committerTom Lane2004-01-08 23:40:27 +0000
commit5390e284dbf12bf4196576466dae1f5c170d0327 (patch)
tree930b7363d8d32067470763670ba5d6e8cfb15c0d /contrib/intarray
parentbd98d159ebaf6138541b81e997fd418e6e07722f (diff)
Remove broken (and unnecessary) definition of operator <> for _int4
datatype; the generic array comparators added in 7.4 supersede this. Per report and patch from Korea PostgreSQL Users' Group.
Diffstat (limited to 'contrib/intarray')
-rw-r--r--contrib/intarray/_int.sql.in22
1 files changed, 11 insertions, 11 deletions
diff --git a/contrib/intarray/_int.sql.in b/contrib/intarray/_int.sql.in
index 2c30bac99e5..472cd1dc1c7 100644
--- a/contrib/intarray/_int.sql.in
+++ b/contrib/intarray/_int.sql.in
@@ -140,15 +140,15 @@ CREATE OPERATOR && (
-- SORT2 = '<'
--);
-CREATE OPERATOR <> (
- LEFTARG = _int4,
- RIGHTARG = _int4,
- PROCEDURE = _int_different,
- COMMUTATOR = '<>',
- NEGATOR = '=',
- RESTRICT = neqsel,
- JOIN = neqjoinsel
-);
+--CREATE OPERATOR <> (
+-- LEFTARG = _int4,
+-- RIGHTARG = _int4,
+-- PROCEDURE = _int_different,
+-- COMMUTATOR = '<>',
+-- NEGATOR = '=',
+-- RESTRICT = neqsel,
+-- JOIN = neqjoinsel
+--);
CREATE OPERATOR @ (
LEFTARG = _int4,
@@ -343,7 +343,7 @@ LANGUAGE 'C';
CREATE OPERATOR CLASS gist__int_ops
DEFAULT FOR TYPE _int4 USING gist AS
OPERATOR 3 &&,
- OPERATOR 6 = RECHECK,
+ OPERATOR 6 = (anyarray, anyarray) RECHECK,
OPERATOR 7 @,
OPERATOR 8 ~,
OPERATOR 20 @@ (_int4, query_int),
@@ -418,7 +418,7 @@ CREATE OPERATOR CLASS gist__intbig_ops
FOR TYPE _int4 USING gist
AS
OPERATOR 3 && RECHECK,
- OPERATOR 6 = RECHECK,
+ OPERATOR 6 = (anyarray, anyarray) RECHECK,
OPERATOR 7 @ RECHECK,
OPERATOR 8 ~ RECHECK,
OPERATOR 20 @@ (_int4, query_int) RECHECK,