operator does not exist

Поиск
Список
Период
Сортировка
От Julius Tuskenis
Тема operator does not exist
Дата
Msg-id 4BA32695.1090402@nsoft.lt
обсуждение исходный текст
Ответы Re: operator does not exist  (Dimitri Fontaine <dfontaine@hi-media.com>)
Re: operator does not exist  (Tom Lane <tgl@sss.pgh.pa.us>)
Список 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 по дате отправления:

Предыдущее
От: Kiswono Prayogo
Дата:
Сообщение: Re: Postgesql and SSL
Следующее
От: Dimitri Fontaine
Дата:
Сообщение: Re: operator does not exist