Adrian Klaver <adrian.klaver@xxxxxxxxx> wrote: > On 02/08/2013 12:23 PM, AI Rumman wrote: >> I got a bit confused after installing this version. So far I used to >> know that from Postgresql 8.3 implicit casting has been removed and the >> following should not work at 8.3 : >> create table testtab ( id varchar, id1 int) >> insert into testtab values (1,1); >> >> Where it was good to work at 8.1 >> >> http://osdir.com/ml/pgsql-general/2011-02/msg00055.html >> >> I also faced the problem earlier. >> >> But in 9.2 it is working perfectly. >> Am I missing any release notes? >> >> Please share your opinion. It will be appreciated. > > As I remember implicit casting was not entirely removed and the > text <--> int combination was kept. I think it has more to do with retaining (or adding back, I don't recall) *assignment* casts which aren't supported as *implicit* casts. test=# select '1'::int = '1'::text; ERROR: operator does not exist: integer = text LINE 1: select '1'::int = '1'::text; ^ HINT: No operator matches the given name and argument type(s). You might need to add explicit type casts. -Kevin -- Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
