From: | "A(dot) Kretschmer" <andreas(dot)kretschmer(at)schollglas(dot)com> |
---|---|
To: | pgsql-general(at)postgresql(dot)org |
Subject: | Re: Error in Trigger function. How to correct? |
Date: | 2010-04-14 13:19:15 |
Message-ID: | 20100414131915.GI1099@a-kretschmer.de |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
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
From | Date | Subject | |
---|---|---|---|
Next Message | Satish Burnwal (sburnwal) | 2010-04-14 13:20:13 | Re: Query is stuck |
Previous Message | Pavel Stehule | 2010-04-14 13:16:52 | Re: Can you please let me know? |