Re: regular expression substittion function?
От | Bruce Momjian |
---|---|
Тема | Re: regular expression substittion function? |
Дата | |
Msg-id | 200102151601.LAA16504@candle.pha.pa.us обсуждение исходный текст |
Ответ на | regular expression substittion function? (Bruno Wolff III <bruno@wolff.to>) |
Ответы |
Re: regular expression substittion function?
Re: regular expression substittion function? |
Список | pgsql-general |
I thought someone suggested that, but I can't remember what happened to it. We have a Perl internal language that works in 7.1beta. You basically want a sed-type ability. I can see real value in that. > 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 по дате отправления: