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.rei...@opendb.com.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.rei...@opendb.com.br >
