operator does not exist

From: Julius Tuskenis <julius(at)nsoft(dot)lt>
To: pgsql-admin(at)postgresql(dot)org
Subject: operator does not exist
Date: 2010-03-19 07:24:05
Message-ID: 4BA32695.1090402@nsoft.lt
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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

Responses

Browse pgsql-admin by date

  From Date Subject
Next Message Dimitri Fontaine 2010-03-19 09:16:01 Re: operator does not exist
Previous Message Kiswono Prayogo 2010-03-19 07:14:35 Re: Postgesql and SSL