Re: question about plpgsql replace function

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