Re:

The PG version I'm using is 9.2.4.

It works but after recreating the implicit cast with the function:

CREATE FUNCTION pg_catalog.text(integer) RETURNS text STRICT IMMUTABLE
LANGUAGE SQL AS 'SELECT textin(int4out($1));';
CREATE CAST (integer AS text) WITH FUNCTION pg_catalog.text(integer) AS
IMPLICIT;

it does not work anymore, even using the explicit cast:

select 'teste'||1::int;
ERROR: operator is not unique: unknown || integer
LINE 1: select 'teste'||1::int;
^
HINT: Could not choose a best candidate operator. You might need to add
explicit type casts.

********** Error **********

ERROR: operator is not unique: unknown || integer
SQL state: 42725
Hint: Could not choose a best candidate operator. You might need to add
explicit type casts.
Character: 15

On Wed, May 15, 2013 at 4:45 PM, AI Rumman <rummandba(at)gmail(dot)com> wrote:

> Ah! I missed that.
> Which version of 9.2 you are working with? I am also at 9.2 and its
> working fine.
> Try out using
> select 'teste'||1::int;
>
> See if it works or not.
>
>
> On Wed, May 15, 2013 at 3:41 PM, Carlos Henrique Reimer <
> carlos(dot)reimer(at)opendb(dot)com(dot)br> wrote:
>
>> Actually, as stated in my first note, this is what I've done to fix the
>> select 2 (select trim(1);) but after creating this function/cast the select
>> 1 (select 'teste'||1;) started not working.
>>
>>
>> On Wed, May 15, 2013 at 4:24 PM, AI Rumman <rummandba(at)gmail(dot)com> wrote:
>>
>>> Create the functions:
>>> CREATE FUNCTION pg_catalog.text(integer) RETURNS text STRICT IMMUTABLE
>>> LANGUAGE SQL AS 'SELECT textin(int4out($1));';
>>> CREATE CAST (integer AS text) WITH FUNCTION pg_catalog.text(integer) AS
>>> IMPLICIT;
>>>
>>> http://www.rummandba.com/2010/10/migrate-database-from-postgresql-81-to.html
>>>
>>> It'll work.
>>>
>>>
>>> On Wed, May 15, 2013 at 3:17 PM, Carlos Henrique Reimer <
>>> carlos(dot)reimer(at)opendb(dot)com(dot)br> wrote:
>>>
>>>> Hi,
>>>>
>>>> Currently, our application is still using PG 8.2 and we are trying to
>>>> use 9.2 but there are some problems related with the implicit casts removed
>>>> on 8.3.
>>>>
>>>> Example:
>>>>
>>>> 1) select 'teste'||1;
>>>> 2) select trim(1);
>>>>
>>>> Select 1 & 2 does run fine on 8.2 but in 9.2 select 1 is ok and select
>>>> 2 got an error due the fact implicit cast were removed on PG 8.3:
>>>>
>>>> ERROR: function pg_catalog.btrim(integer) does not exist
>>>> LINE 1: select trim(1);
>>>> ^
>>>> HINT: No function matches the given name and argument types. You might
>>>> need to add explicit type casts.
>>>>
>>>> ********** Error **********
>>>>
>>>> ERROR: function pg_catalog.btrim(integer) does not exist
>>>> SQL state: 42883
>>>> Hint: No function matches the given name and argument types. You might
>>>> need to add explicit type casts.
>>>> Character: 8
>>>>
>>>> Recreated the implicit cast for select 2:
>>>>
>>>> CREATE FUNCTION pg_catalog.text(integer) RETURNS text STRICT IMMUTABLE
>>>> LANGUAGE SQL AS 'SELECT textin(int4out($1));';
>>>> CREATE CAST (integer AS text) WITH FUNCTION pg_catalog.text(integer) AS
>>>> IMPLICIT;
>>>>
>>>> Now select 2 works fine but select 1 gets an error:
>>>>
>>>> ERROR: operator is not unique: unknown || integer
>>>> LINE 1: select 'teste'||1;
>>>> ^
>>>> HINT: Could not choose a best candidate operator. You might need to
>>>> add explicit type casts.
>>>>
>>>> ********** Error **********
>>>>
>>>> ERROR: operator is not unique: unknown || integer
>>>> SQL state: 42725
>>>> Hint: Could not choose a best candidate operator. You might need to add
>>>> explicit type casts.
>>>> Character: 15
>>>>
>>>>
>>>> Is there a way to make both selects work on PG 9.2 without explicit
>>>> casts?
>>>>
>>>> Thank you in advace!
>>>>
>>>> --
>>>> Reimer
>>>> 47-3347-1724 47-9183-0547 msn: carlos(dot)reimer(at)opendb(dot)com(dot)br
>>>>
>>>
>>>
>>
>>
>> --
>> Reimer
>> 47-3347-1724 47-9183-0547 msn: carlos(dot)reimer(at)opendb(dot)com(dot)br
>>
>
>

--
Reimer
47-3347-1724 47-9183-0547 msn: carlos(dot)reimer(at)opendb(dot)com(dot)br