Trying to create implicit casts to text in PG 8.3

From: Aleksander Kmetec <aleksander(dot)kmetec(at)intera(dot)si>
To: pgsql-general <pgsql-general(at)postgresql(dot)org>
Subject: Trying to create implicit casts to text in PG 8.3
Date: 2009-01-13 04:54:25
Message-ID: 496C1E81.6060208@intera.si
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

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?

Regards,
Aleksander

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Christian Schröder 2009-01-13 07:23:00 Re: Query planner and foreign key constraints
Previous Message Scott Marlowe 2009-01-13 04:18:58 Re: [pgsql-advocacy] PgUS 2008 end of year summary