Re: regexp_replace

Поиск
Список
Период
Сортировка
От Andrew Dunstan
Тема Re: regexp_replace
Дата
Msg-id 42C00402.8030409@dunslane.net
обсуждение исходный текст
Ответ на regexp_replace  (Atsushi Ogawa <a_ogawa@hi-ho.ne.jp>)
Ответы Re: regexp_replace  (Bruce Momjian <pgman@candle.pha.pa.us>)
Список pgsql-patches
I'm very glad to see this. But is a nicer name possible? To perl
programmers at least, "substitute" should make sense.

cheers

andrew

Atsushi Ogawa wrote:

>I made the patch that implements regexp_replace again.
>The specification of this function is as follows.
>
>regexp_replace(source text, pattern text, replacement text, [flags text])
>returns text
>
>Replace string that matches to regular expression in source text to
>replacement text.
>
> - pattern is regular expression pattern.
> - replacement is replace string that can use '\1'-'\9', and '\&'.
>    '\1'-'\9': back reference to the n'th subexpression.
>    '\&'     : entire matched string.
> - flags can use the following values:
>    g: global (replace all)
>    i: ignore case
>    When the flags is not specified, case sensitive, replace the first
>    instance only.
>
>regards,
>
>--- Atsushi Ogawa
>
>
>------------------------------------------------------------------------
>
>
>---------------------------(end of broadcast)---------------------------
>TIP 4: Don't 'kill -9' the postmaster
>
>

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

Предыдущее
От: Karel Zak
Дата:
Сообщение: Re: Implementing SELECT FOR UPDATE [NOWAIT]
Следующее
От: Tom Lane
Дата:
Сообщение: Re: limiting connections per user/database