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/
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!! |