Patch of intarray module in v7.4.1
От | Korea PostgreSQL Users' Group |
---|---|
Тема | Patch of intarray module in v7.4.1 |
Дата | |
Msg-id | 20040108062553.GA12342@postgresql.or.kr обсуждение исходный текст |
Ответы |
Re: Patch of intarray module in v7.4.1
|
Список | pgsql-patches |
In 7.4.1, intarray module have a problme about equal operator (=). select * from table where intarray_column = '{}'; above query make error. because when not equal operator (<>) is made, this make incorrect equal operator by implicate. so, I patched. Patch content is here. ===== BEGIN of FILE ===== --- _int.sql.in.orig Thu Jun 12 03:44:15 2003 +++ _int.sql.in Wed Jan 7 13:14:37 2004 @@ -140,15 +140,15 @@ -- 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 @@ 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 @@ 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, ===== End of FILE =====
В списке pgsql-patches по дате отправления: