Re: BUG #3661: Missing equality comparator: string = integer - Mailing list pgsql-bugs

From Peter Eisentraut
Subject Re: BUG #3661: Missing equality comparator: string = integer
Date
Msg-id 200710091904.49876.peter_e@gmx.net
Whole thread Raw
In response to BUG #3661: Missing equality comparator: string = integer  ("David Bachmann" <david.bachmann@ersystems.ch>)
List pgsql-bugs
Am Dienstag, 9. Oktober 2007 schrieb David Bachmann:
> This does not function any more under PG 8.3-beta1:
>
> select '5'::varchar = 5;
> ERROR:  operator does not exist: character varying = integer

That is intentional.  Fix your application by inserting appropriate explicit
casts.

--
Peter Eisentraut
http://developer.postgresql.org/~petere/

pgsql-bugs by date:

Previous
From: "Hiroshi Saito"
Date:
Subject: Re: BUG #3663: Installer: Encoding(Server) Select list have not UTF-8 encoding.
Next
From: "Pavel Stehule"
Date:
Subject: Re: BUG #3661: Missing equality comparator: string = integer