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
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 |