Re: Autocast script of peter e in PostgreSQL 8.3 - Mailing list pgsql-general

From Martijn van Oosterhout
Subject Re: Autocast script of peter e in PostgreSQL 8.3
Date
Msg-id 20080506123905.GF19090@svana.org
Whole thread Raw
In response to Autocast script of peter e in PostgreSQL 8.3  (Daniel Schuchardt <daniel_schuchardt@web.de>)
Responses Re: Autocast script of peter e in PostgreSQL 8.3  (Daniel Schuchardt <daniel_schuchardt@web.de>)
List pgsql-general
On Tue, May 06, 2008 at 02:09:30PM +0200, Daniel Schuchardt wrote:
> *SCDS=# SELECT 1||'~'||1;
> ERROR:  operator is not unique: integer || unknown at character 9
> HINT:  Could not choose a best candidate operator. You might need to add
> explicit type casts.
> LINE 1: SELECT 1||'~'||1;

Check the archives. I think Tom pointed out that while it readds all
the casts, some other changes were made for the '||' operator and you
need to delete those. IIRC you need to manipuate the catalog tables
directly for that.

Have a nice day,
--
Martijn van Oosterhout   <kleptog@svana.org>   http://svana.org/kleptog/
> Please line up in a tree and maintain the heap invariant while
> boarding. Thank you for flying nlogn airlines.

Attachment

pgsql-general by date:

Previous
From: "Javier Olazaguirre"
Date:
Subject: Re: Speed up repetitive queries
Next
From: "Scott Miller"
Date:
Subject: Re: Feature request