| From: | Atsushi Ogawa <a_ogawa(at)hi-ho(dot)ne(dot)jp> | 
|---|---|
| To: | pgsql-patches(at)postgresql(dot)org | 
| Subject: | regexp_replace | 
| Date: | 2005-06-27 13:14:44 | 
| Message-ID: | PIEMIKOOMKNIJLLLBCBBCEADCJAA.a_ogawa@hi-ho.ne.jp | 
| Views: | Whole Thread | Raw Message | Download mbox | Resend email | 
| Thread: | |
| Lists: | pgsql-patches | 
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
| Attachment | Content-Type | Size | 
|---|---|---|
| regexp_replace.patch | application/octet-stream | 20.3 KB | 
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Karel Zak | 2005-06-27 13:48:54 | Re: Implementing SELECT FOR UPDATE [NOWAIT] | 
| Previous Message | Petr Jelínek | 2005-06-27 11:45:37 | Re: limiting connections per user/database |