Re: regular expression substittion function?

Поиск
Список
Период
Сортировка
От Bruce Momjian
Тема Re: regular expression substittion function?
Дата
Msg-id 200102151602.LAA16607@candle.pha.pa.us
обсуждение исходный текст
Ответ на regular expression substittion function?  (Bruno Wolff III <bruno@wolff.to>)
Список pgsql-general
Added to TODO:

    * Add sed-like regular expression search/replace capability

> Are there any plans to provide a regular expression substitution function,
> similar to translate but allowing more complex substitutions?
>
> This is an example of what I want to use it for. I am using a query that
> builds web urls from a couple of different types of data and then union
> together. Some of the data is raw urls, and some is title information
> that gets turn into search urls. The title information needs to be
> massaged before being used in a url and it needs to be done in the query
> if I want to do the union. The translate command could be used in my
> particular case, but it will be very long, as I need to delete most
> nonletter nondigit characters and change spaces to plusses. A regular
> expression describing what I want would be much more compact.
>


--
  Bruce Momjian                        |  http://candle.pha.pa.us
  pgman@candle.pha.pa.us               |  (610) 853-3000
  +  If your life is a hard drive,     |  830 Blythe Avenue
  +  Christ can be your backup.        |  Drexel Hill, Pennsylvania 19026

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

Предыдущее
От: Louis-David Mitterrand
Дата:
Сообщение: cleaning out template1, and what is template0?
Следующее
От: David Wheeler
Дата:
Сообщение: Re: regular expression substittion function?