Re: Fwd: Casting issue!!

Hi Jose,

why haven't you post an example of the failing query, data and the exact
error message? The casting should work on 8.3 (and it works for me) so I
guess there are some invalid data, invalid SQL or something like that.

Anyway I doubt this is a performance issue - this falls into generic SQL
mailing list.

regards
Tomas

> ---------- Forwarded message ----------
> From: jose fuenmayor <jafn82(at)gmail(dot)com>
> Date: Wed, Jan 7, 2009 at 2:56 PM
> Subject: Casting issue!!
> To: psql-admin(at)postgresql(dot)org
>
>
> Hi all I am trying to migrate from postgresql 8.2.x to 8.3.x, i have an
> issue with casting values when i try to perform the auto cast , it does
> not
> work and I get an error, how can i perform auto casting on 8.3 without
> rewrite my source code, I am using pl/pgsql. I mean i dont want to write
> value::dataType. I dont want to use explicit type cast. Maybe change
> something in the config files? to make it work like 8.2 on tha regard(cast
> values).
> thanks a lot!!!
> Kind Regards;
> Jose Fuenmayor
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
> ç
>