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 <rumman...@gmail.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.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 >> > > -- Reimer 47-3347-1724 47-9183-0547 msn: carlos.rei...@opendb.com.br
