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

From David Bachmann
Subject BUG #3661: Missing equality comparator: string = integer
Date
Msg-id 200710091549.l99FnSFu028067@wwwmaster.postgresql.org
Whole thread Raw
Responses Re: BUG #3661: Missing equality comparator: string = integer
Re: BUG #3661: Missing equality comparator: string = integer
List pgsql-bugs
The following bug has been logged online:

Bug reference:      3661
Logged by:          David Bachmann
Email address:      david.bachmann@ersystems.ch
PostgreSQL version: 8.3-beta1
Operating system:   Windows XP
Description:        Missing equality comparator: string = integer
Details:

This does not function any more under PG 8.3-beta1:

select '5'::varchar = 5;
ERROR:  operator does not exist: character varying = integer

select '5'::char = 5;
ERROR:  operator does not exist: character = integer


Note that this still works:
select '5' = 5;

pgsql-bugs by date:

Previous
From: "blay bloo"
Date:
Subject: plpythonu execute - create function bug?
Next
From: "Robins Tharakan"
Date:
Subject: BUG #3662: Seems that more than one run of a functions causes an error