From: Glyn Astill <glynastill@yahoo.co.uk>
To: tgl@sss.pgh.pa.us, pgsql-performance@postgresql.org, jose fuenmayor <jafn82@gmail.com>
Subject: Re: Fwd: Casting issue!!
Date: Wed, 7 Jan 2009 15:16:44 +0000 (GMT)
Message-ID: <867853.42842.qm@web23605.mail.ird.yahoo.com> (raw)
In-Reply-To: <69f2062a0901070558v3fc1f8fds1053270abbea242d@mail.gmail.com>
--- 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/
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-performance@postgresql.org
Cc: glynastill@yahoo.co.uk, jafn82@gmail.com
Subject: Re: Fwd: Casting issue!!
In-Reply-To: <867853.42842.qm@web23605.mail.ird.yahoo.com>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox