Re: no implicit cast error in 9.2? - Mailing list pgsql-general

From Adrian Klaver
Subject Re: no implicit cast error in 9.2?
Date
Msg-id 511591FC.1070507@gmail.com
Whole thread Raw
In response to Re: no implicit cast error in 9.2?  (Kevin Grittner <kgrittn@ymail.com>)
List pgsql-general
On 02/08/2013 01:50 PM, Kevin Grittner wrote:
> Adrian Klaver <adrian.klaver@gmail.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.

Ah, so that is the reason. A distinction I missed:(



--
Adrian Klaver
adrian.klaver@gmail.com

pgsql-general by date:

Previous
From: Tom Lane
Date:
Subject: Re: Swapping volumes under tablespaces: supported?
Next
From: Tom Lane
Date:
Subject: Re: Restoring a database dump from 9.0 to 9.2