question about plpgsql replace function

From: Tony Caduto <tony_caduto(at)amsoftwaredesign(dot)com>
To:
Cc: pgsql-general(at)postgresql(dot)org
Subject: question about plpgsql replace function
Date: 2005-08-19 16:11:31
Message-ID: 430604B3.4090304@amsoftwaredesign.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

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

In response to

  • Re: at 2005-08-19 15:58:56 from A. Kretschmer

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Peter Fein 2005-08-19 16:12:57 Re: plpython function with dictionary as function argument?
Previous Message A. Kretschmer 2005-08-19 15:58:56 Re: