Re: regexp_replace - Mailing list pgsql-patches

From Andrew Dunstan
Subject Re: regexp_replace
Date
Msg-id 42C00402.8030409@dunslane.net
Whole thread Raw
In response to regexp_replace  (Atsushi Ogawa <a_ogawa@hi-ho.ne.jp>)
Responses Re: regexp_replace
List 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 by date:

Previous
From: Karel Zak
Date:
Subject: Re: Implementing SELECT FOR UPDATE [NOWAIT]
Next
From: Tom Lane
Date:
Subject: Re: limiting connections per user/database