question about plpgsql replace function

Поиск
Список
Период
Сортировка
От Tony Caduto
Тема question about plpgsql replace function
Дата
Msg-id 430604B3.4090304@amsoftwaredesign.com
обсуждение исходный текст
Ответ на Re:  ("A. Kretschmer" <akretschmer@despammed.com>)
Ответы Re: question about plpgsql replace function  (Tom Lane <tgl@sss.pgh.pa.us>)
Postgresql Function Language question  (Tony Caduto <tony_caduto@amsoftwaredesign.com>)
Re: question about plpgsql replace function  (Michael Fuhr <mike@fuhr.org>)
Список 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

В списке pgsql-general по дате отправления:

Предыдущее
От: Peter Fein
Дата:
Сообщение: Re: plpython function with dictionary as function argument?
Следующее
От: Tom Lane
Дата:
Сообщение: Re: How to cancel a query if SIGINT does not work?