Re: regular expression substittion function? - Mailing list pgsql-general

From Bruce Momjian
Subject Re: regular expression substittion function?
Date
Msg-id 200102151602.LAA16607@candle.pha.pa.us
Whole thread Raw
In response to regular expression substittion function?  (Bruno Wolff III <bruno@wolff.to>)
List 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 by date:

Previous
From: Louis-David Mitterrand
Date:
Subject: cleaning out template1, and what is template0?
Next
From: David Wheeler
Date:
Subject: Re: regular expression substittion function?