DomainKey-Signature: a=rsa-sha1; q=dns; c=nofws; s=s1024; d=yahoo.co.uk;
	h=X-YMail-OSG:Received:X-Mailer:Date:From:Reply-To:Subject:To:In-Reply-To:MIME-Version:Content-Type:Content-Transfer-Encoding:Message-ID;
	b=Pm7H3ZkwH4LDgYBarb6hwljqBFanw/p0xZsshQ5k4LyVakdgMxN/gMcoGLIMSnjq0JYuZjpsooFSY/HX3mln2ojeSXKJoQIVf11ABoMbA0Toq6f2uj2qAeFTyFHA9JjmeJeImLW1n1XB9M03FQZDGlUdf31hFRELwS7CdOwZcDE=;
Date: Wed, 7 Jan 2009 15:16:44 +0000 (GMT)
From: Glyn Astill <glynastill@yahoo.co.uk>
Reply-To: glynastill@yahoo.co.uk
Subject: Re: Fwd: Casting issue!!
To: tgl@sss.pgh.pa.us, pgsql-performance@postgresql.org,
	jose fuenmayor <jafn82@gmail.com>
In-Reply-To: <69f2062a0901070558v3fc1f8fds1053270abbea242d@mail.gmail.com>
MIME-Version: 1.0
Content-Type: text/plain; charset=utf-8
Content-Transfer-Encoding: quoted-printable
Message-ID: <867853.42842.qm@web23605.mail.ird.yahoo.com>


--- On Wed, 7/1/09, jose fuenmayor <jafn82@gmail.com> wrote:
>=20
> Hi all I am trying to migrate from postgresql 8.2.x to=20
> 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-gene=
ral list.

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

http://www.depesz.com/index.php/2008/05/05/error-operator-does-not-exist-in=
teger-text-how-to-fix-it/
=0A=0A=0A