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 |
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 |