From: Julius Tuskenis <julius@nsoft.lt>
To: pgsql-admin@postgresql.org
Subject: operator does not exist
Date: Fri, 19 Mar 2010 09:24:05 +0200
Message-ID: <4BA32695.1090402@nsoft.lt> (raw)
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
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-admin@postgresql.org
Cc: julius@nsoft.lt
Subject: Re: operator does not exist
In-Reply-To: <4BA32695.1090402@nsoft.lt>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox