regexp_replace

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: Raw Message | Whole Thread | 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

Responses

Browse pgsql-patches by date

  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