Re: Trying to create implicit casts to text in PG 8.3

2009/1/13 Aleksander Kmetec <aleksander(dot)kmetec(at)intera(dot)si>:
> Hi, everyone.
>
> I'm trying to upgrade a database which is used by several hundred
> installations of an app; with each installation possibly running some custom
> code and 3rd party extensions. I was hoping that it would be possible to
> re-add implicit casts to text for bacwards compatibility with 8.2, since
> that would be much easier and smoother than testing all those installations
> and/or waiting for bug reports to start pouring in...
>
> I tried adding casts found here:
> http://code.open-bio.org/svnweb/index.cgi/biosql/revision?rev=284
>
> Function calls work fine now, but a new problem appeared with operators:
> SELECT EXTRACT(DAY FROM NOW()) || 'abc';
> ERROR: operator is not unique: double precision || unknown
>
> Is there a way to get around this?
>

You add the cast's but not the operator.
The cast is in other way (try to compare with a text '13')
for example.

>
> Regards,
> Aleksander
>
> --
> Sent via pgsql-general mailing list (pgsql-general(at)postgresql(dot)org)
> To make changes to your subscription:
> http://www.postgresql.org/mailpref/pgsql-general
>

--
Emanuel Calvo Franco
ArPUG / AOSUG Member
Postgresql Support & Admin