Thread: Fwd: Casting issue!!

On Wed, 7 Jan 2009, jose fuenmayor wrote:
> 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).

What does that have to do with performance?

Matthew

--
Illiteracy - I don't know the meaning of the word!

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@gmail.com>
> Date: Wed, Jan 7, 2009 at 2:56 PM
> Subject: Casting issue!!
> To: psql-admin@postgresql.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
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
> ç
>

--- On Wed, 7/1/09, jose fuenmayor <jafn82@gmail.com> wrote:
>
> 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

As the others have said; you'd be better off posting this in the pgsql-general list.

However I think you could proabably work your way around this with a function and a cast, as described here:

http://www.depesz.com/index.php/2008/05/05/error-operator-does-not-exist-integer-text-how-to-fix-it/