From: | Emanuel Calvo Franco <postgres(dot)arg(at)gmail(dot)com> |
---|---|
To: | General PostgreSQL List <pgsql-general(at)postgresql(dot)org> |
Subject: | Re: Trying to create implicit casts to text in PG 8.3 |
Date: | 2009-01-13 12:19:21 |
Message-ID: | f205bb120901130419j65781270qddc1a374d7956369@mail.gmail.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
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
From | Date | Subject | |
---|---|---|---|
Next Message | Alvaro Herrera | 2009-01-13 12:25:50 | Re: [GENERAL] PgUS 2008 end of year summary |
Previous Message | Ivan Sergio Borgonovo | 2009-01-13 12:01:13 | limit and other joined tables |