On 05/28/2010 01:51 PM, Adrian Klaver wrote:
> On 05/28/2010 11:45 AM, erobles wrote:
>>
>>
>> On 05/28/2010 01:26 PM, Adrian Klaver wrote:
>>> On 05/28/2010 11:20 AM, erobles wrote:
>>>> hi!
>>>> only for ask, there is a way to deactivate type validation, so i
>>>> can do
>>>>
>>>> select rtrim(number_field) from table ; with no error and the message:
>>>> "You might need to explicit type casts"
>>>>
>>>> this is postgres 8.3.1.
>>>>
>>>
>>> What are you trying to do? I am trying to think what rtrim does on a
>>> number.
>>>
>>
>>
>> you are right, i'm trying to make a rtrim to a number.
>> the reason of my question is we have a lot of apps with similar querys ,
>> when we have postgres7.2 this kind of querys just simply execute very
>> well, so.. when change to postgres 8.3 this querys fail beacuse they
>> needit an explicit cast.
>>
>> one solution is change the querys of apps and recompile, but time is
>> short and the deadline is near.
>>
>> other solution is create a function to each explicit cast, but we dont
>> have the time to research if there are more mismatch querys.
>>
>> so the easy way is deactivate the validation type ...
>>
>>
>>
>>
>>
>> so another
>>
> For short term solution see here:
> http://petereisentraut.blogspot.com/2008/03/readding-implicit-casts-in-postgresql.html
>
>
>
thanks, downloading and testing.....
