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

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

2007-10-09 Thread David Bachmann
The following bug has been logged online: Bug reference: 3661 Logged by: David Bachmann Email address: [EMAIL PROTECTED] PostgreSQL version: 8.3-beta1 Operating system: Windows XP Description:Missing equality comparator: string = integer Details: This does not funct