Re: no implicit cast error in 9.2?

Adrian Klaver <adrian.klaver@gmail.com> wrote:=0A> On 02/08/2013 12:23 PM, =
AI Rumman wrote:=0A=0A>> I got a bit confused after installing this version=
. So far I used to=0A>> know that from Postgresql 8.3 implicit casting has =
been removed and the=0A>> following should not work at 8.3 :=0A>> create ta=
ble testtab ( id varchar, id1 int)=0A>> insert into testtab values (1,1);=
=0A>>=0A>> Where it was good to work at 8.1=0A>>=0A>> http://osdir.com/ml/p=
gsql-general/2011-02/msg00055.html=0A>>=0A>> I also faced the problem earli=
er.=0A>>=0A>> But in 9.2 it is working perfectly.=0A>> Am I missing any rel=
ease notes?=0A>>=0A>> Please share your opinion. It will be appreciated.=0A=
>=0A> As I remember implicit casting was not entirely removed and the=0A> t=
ext <--> int combination was kept.=0A=0AI think it has more to do with reta=
ining (or adding back, I don't=0Arecall) *assignment* casts which aren't su=
pported as *implicit*=0Acasts.=0A=0Atest=3D# select '1'::int =3D '1'::text;=
=0AERROR:=A0 operator does not exist: integer =3D text=0ALINE 1: select '1'=
::int =3D '1'::text;=0A=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=
=A0=A0=A0=A0=A0=A0 ^=0AHINT:=A0 No operator matches the given name and argu=
ment type(s). You might need to add explicit type casts.=0A=0A-Kevin=0A