Re: Fwd: Casting issue!!

From: Glyn Astill <glynastill(at)yahoo(dot)co(dot)uk>
To: tgl(at)sss(dot)pgh(dot)pa(dot)us, pgsql-performance(at)postgresql(dot)org, jose fuenmayor <jafn82(at)gmail(dot)com>
Subject: Re: Fwd: Casting issue!!
Date: 2009-01-07 15:16:44
Message-ID: 867853.42842.qm@web23605.mail.ird.yahoo.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-performance

--- On Wed, 7/1/09, jose fuenmayor <jafn82(at)gmail(dot)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/

In response to

Browse pgsql-performance by date

  From Date Subject
Next Message M. Edward (Ed) Borasky 2009-01-07 15:35:23 Re: understanding postgres issues/bottlenecks
Previous Message tv 2009-01-07 14:07:10 Re: Fwd: Casting issue!!