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
Re: BUG #3092: character varying and integer cannot be matched |
Список | 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 по дате отправления: