# I need to to change an ip addres in a plpgsql function from
# aaa.bbb.ccc.ddd to an sring containing "aaa bbb ccc ddd upload".
sklassen=> select replace('216.237.145.1'::text, '.', ' ') || ' upload';
?column?
--
216 237 145 1 upload
(1 row)
--
Steven Klassen
You need to "replace" into something. Try
my_ipaddress_as_text := replace(my_ipaddress_as_text,''.'','' '');
Also, the concat operator is ||, not just one |.
Hope that helps!
On Tue, 28 Dec 2004 22:32:47 +0100, Joost Kraaijeveld
<[EMAIL PROTECTED]> wrote:
> Hi all,
>
> I need to to change
Hi all,
I need to to change an ip addres in a plpgsql function from aaa.bbb.ccc.ddd to
an sring containing "aaa bbb ccc ddd upload".
The following code does not work. It complaines about the replace line (or is
it the assignment?):
ERROR: syntax error at or near "replace" at character 1
CONT
