operator does not exist
От | Julius Tuskenis |
---|---|
Тема | operator does not exist |
Дата | |
Msg-id | 4BA32695.1090402@nsoft.lt обсуждение исходный текст |
Ответы |
Re: operator does not exist
Re: operator does not exist |
Список | pgsql-admin |
Hello, we updated one of our systems from postgresql 8.2 to 8.3 and now some queries are generating errors that no operator matches the given name and argument type. That is not surprising as in v8.3 the automatic casting was removed what troubles me is that sometimes it still casts select '1' = 1 results in true while select sum(msg_price) from messages where msg_itemid = 0 results in error: ERROR: operator does not exist: character varying = integer LINE 1: select sum(msg_price) from messages where msg_itemid = 0 I will add the operator ant then we'll fix the queries, but is the first example ok? Should it not raise error ? -- Julius Tuskenis Programavimo skyriaus vadovas UAB nSoft mob. +37068233050
В списке pgsql-admin по дате отправления: