Re: no implicit cast error in 9.2?

Adrian Klaver <adrian(dot)klaver(at)gmail(dot)com> 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