BUG #3092: character varying and integer cannot be matched

Поиск
Список
Период
Сортировка
От Andrew Rass
Тема BUG #3092: character varying and integer cannot be matched
Дата
Msg-id 200703011020.l21AKHYO075157@wwwmaster.postgresql.org
обсуждение исходный текст
Ответы Re: BUG #3092: character varying and integer cannot be matched  (Peter Eisentraut <peter_e@gmx.net>)
Re: BUG #3092: character varying and integer cannot be matched  (Tom Lane <tgl@sss.pgh.pa.us>)
Список pgsql-bugs
The following bug has been logged online:

Bug reference:      3092
Logged by:          Andrew Rass
Email address:      net-flight@gmx.net
PostgreSQL version: 8.2.3
Operating system:   FreeBSD 6.2
Description:        character varying and integer cannot be matched
Details:

Hello the following problem has occured,

SELECT T055.MESOPRIM,T051.MESOPRIM FROM T055 T055,T051 T051
WHERE T055.MESOYEAR = 1278 AND T055.MESOCOMP = '1ZAP'
AND T051.MESOYEAR = 1278 AND T051.MESOCOMP = '1ZAP'
AND ( T055.C002 = T051.C001 AND T055.C004 IN (2,3)
AND lower(t051.c052)  LIKE '%frankfurt%' )ORDER BY T055.C002


ERROR: IN types character varying and integer cannot be matched
SQL Status:42804

mesoprim character varying(34);
mesoyear integer;
mesocomp character varying(4);
c002 character varying(20);
c001 character varying(20);

postgresql 7.4.7 did this
and now it did this problem like describe

thank you

В списке pgsql-bugs по дате отправления:

Предыдущее
От: Raymond Naseef
Дата:
Сообщение: Re: BUG #3059: psql to 'postgres' shortcut
Следующее
От: Peter Eisentraut
Дата:
Сообщение: Re: BUG #3092: character varying and integer cannot be matched