In response to Andre Lopes : > Hi, > > I have a trigger that runs in my Development machine but not in my Production > machine. the code is the following: > SQL Error: > > ERROR: function replace(text, unknown, integer) does not exist > LINE 1: select replace(replace(replace(replace(replace(replace( $1 ,... > ^ Let me guess: you have 8.2 on your Development machine and 8.3 or 8.4 on your production machine, right? I think you need to add explicit casts, let me explain: > HINT: No function matches the given name and argument types. You might need to > add explicit type casts. > QUERY: select replace(replace(replace(replace(replace(replace( $1 , > '@numero_anuncio@', a.id_anuncio_externo), '@nome_anuncio@', a.n_anuncio), > '@idade@', EXTRACT(year from AGE(NOW(), a.dat_nasc))), '@telefone_anuncio@', EXTRACT(year ...) returns an INT, but replace(...) expects a TEXT or a similar type. Try to add a ::TEXT after the EXTRACT(...) - function: extract (year from ...)::text Maybe there are more occurrences ... Greetings from saxony, germany. -- Andreas Kretschmer Kontakt: Heynitz: 035242/47150, D1: 0160/7141639 (mehr: -> Header) GnuPG: 0x31720C99, 1006 CCB4 A326 1D42 6431 2EB0 389D 1DC2 3172 0C99 -- Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
