Re: [BUGS] BUG #3661: Missing equality comparator: string = integer

2007-10-09 Thread Pavel Stehule
> > 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 you cannot compare any character type and numeric type. If you wont t

Re: [BUGS] BUG #3661: Missing equality comparator: string = integer

2007-10-09 Thread Peter Eisentraut
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 Eis