Tony Caduto <tony_caduto@xxxxxxxxxxxxxxxxxxxx> 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 ---------------------------(end of broadcast)--------------------------- TIP 4: Have you searched our list archives? http://archives.postgresql.org