Re: [GENERAL] question about plpgsql replace function

2005-08-19 Thread Michael Fuhr
On Fri, Aug 19, 2005 at 11:11:31AM -0500, Tony Caduto wrote: > 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. Your slashes are leaning the

Re: [GENERAL] question about plpgsql replace function

2005-08-19 Thread Tom Lane
Tony Caduto <[EMAIL PROTECTED]> 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.