Movatterモバイル変換


[0]ホーム

URL:


Skip to content

Navigation Menu

Sign in
Appearance settings

Search code, repositories, users, issues, pull requests...

Provide feedback

We read every piece of feedback, and take your input very seriously.

Saved searches

Use saved searches to filter your results more quickly

Sign up
Appearance settings

Commit5390e28

Browse files
committed
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.
1 parentbd98d15 commit5390e28

File tree

1 file changed

+11
-11
lines changed

1 file changed

+11
-11
lines changed

‎contrib/intarray/_int.sql.in

Lines changed: 11 additions & 11 deletions
Original file line numberDiff line numberDiff line change
@@ -140,15 +140,15 @@ CREATE OPERATOR && (
140140
--SORT2 = '<'
141141
--);
142142

143-
CREATE OPERATOR <> (
144-
LEFTARG = _int4,
145-
RIGHTARG = _int4,
146-
PROCEDURE = _int_different,
147-
COMMUTATOR = '<>',
148-
NEGATOR = '=',
149-
RESTRICT = neqsel,
150-
JOIN = neqjoinsel
151-
);
143+
--CREATE OPERATOR <> (
144+
--LEFTARG = _int4,
145+
--RIGHTARG = _int4,
146+
--PROCEDURE = _int_different,
147+
--COMMUTATOR = '<>',
148+
--NEGATOR = '=',
149+
--RESTRICT = neqsel,
150+
--JOIN = neqjoinsel
151+
--);
152152

153153
CREATE OPERATOR @ (
154154
LEFTARG = _int4,
@@ -343,7 +343,7 @@ LANGUAGE 'C';
343343
CREATE OPERATOR CLASS gist__int_ops
344344
DEFAULT FOR TYPE _int4 USING gist AS
345345
OPERATOR3&&,
346-
OPERATOR6=RECHECK,
346+
OPERATOR6= (anyarray, anyarray)RECHECK,
347347
OPERATOR7@,
348348
OPERATOR8~,
349349
OPERATOR20@@ (_int4, query_int),
@@ -418,7 +418,7 @@ CREATE OPERATOR CLASS gist__intbig_ops
418418
FOR TYPE _int4 USING gist
419419
AS
420420
OPERATOR3&&RECHECK,
421-
OPERATOR6=RECHECK,
421+
OPERATOR6= (anyarray, anyarray)RECHECK,
422422
OPERATOR7@RECHECK,
423423
OPERATOR8~RECHECK,
424424
OPERATOR20@@ (_int4, query_int)RECHECK,

0 commit comments

Comments
 (0)

[8]ページ先頭

©2009-2025 Movatter.jp