aboutsummaryrefslogtreecommitdiff
path: root/contrib/intarray
diff options
context:
space:
mode:
authorTom Lane <tgl@sss.pgh.pa.us>2004-01-08 23:40:36 +0000
committerTom Lane <tgl@sss.pgh.pa.us>2004-01-08 23:40:36 +0000
commit2fb41f900a8650737aa37d5aab0e58a0dee94f3d (patch)
tree8901dab4de96dbbe1fef3286f7f6b62e8a3ac178 /contrib/intarray
parentf389ff33c31aec73bdd61675791873d6350d540d (diff)
downloadpostgresql-2fb41f900a8650737aa37d5aab0e58a0dee94f3d.tar.gz
postgresql-2fb41f900a8650737aa37d5aab0e58a0dee94f3d.zip
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,