question about plpgsql replace function

[Tony Caduto <tony_caduto@xxxxxxxxxxxxxxxxxxxx>]

Hi,
I have a text field that has some email addresses that are each on a new 
line by a CRLF.

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.

Does anyone know if it is possible to replace a CRLF in a string with PG 
built in functions?  I would rather not use Perl if possible.

Thanks,

Tony

---------------------------(end of broadcast)---------------------------
TIP 1: if posting/reading through Usenet, please send an appropriate
      subscribe-nomail command to majordomo@xxxxxxxxxxxxxx so that your
      message can get through to the mailing list cleanly