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 <jaf...@gmail.com> > Date: Wed, Jan 7, 2009 at 2:56 PM > Subject: Casting issue!! > To: psql-ad...@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 > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > รง > -- Sent via pgsql-performance mailing list (pgsql-performance@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-performance
