Postgres Pro
Downloads
Home   >   mailing lists

Re: question about plpgsql replace function - Mailing list pgsql-general

From Tom Lane
Subject Re: question about plpgsql replace function
Date
Msg-id 25732.1124469043@sss.pgh.pa.us
Whole thread Raw
In response to question about plpgsql replace function  (Tony Caduto <tony_caduto@amsoftwaredesign.com>)
List pgsql-general
Tree view 
Tony Caduto <tony_caduto@amsoftwaredesign.com> writes:
> I want to replace the CRLF with  a comma so I can use the email
> addresses in another app, so I thought I would do this:

> thearray = replace(mandi_notifications,'/r/n',',');

> but it does not work.

I think you wanted backslashes not forward slashes.

            regards, tom lane

pgsql-general by date:

Previous
From: Tom Lane
Date:
Subject: Re: http://www.postgresql.org/docs/8.0/static/xfunc-sql.html
Next
From: Tony Caduto
Date:
Subject: Postgresql Function Language question