regular expression substittion function?

Поиск
Список
Период
Сортировка
От Bruno Wolff III
Тема regular expression substittion function?
Дата
Msg-id 20010215100054.A30423@wolff.to
обсуждение исходный текст
Ответы Re: regular expression substittion function?  (Tom Lane <tgl@sss.pgh.pa.us>)
Re: regular expression substittion function?  (Bruce Momjian <pgman@candle.pha.pa.us>)
Re: regular expression substittion function?  (Bruce Momjian <pgman@candle.pha.pa.us>)
Список pgsql-general
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.

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

Предыдущее
От: Tom Lane
Дата:
Сообщение: Re: Re: temp table creation
Следующее
От: Michael Ansley
Дата:
Сообщение: RE: DSN-less connection to Postgres-database