diff options
Diffstat (limited to 'doc/src')
| -rw-r--r-- | doc/src/sgml/func.sgml | 22 |
1 files changed, 21 insertions, 1 deletions
diff --git a/doc/src/sgml/func.sgml b/doc/src/sgml/func.sgml index 4ff434aca87..f274e53c552 100644 --- a/doc/src/sgml/func.sgml +++ b/doc/src/sgml/func.sgml @@ -1,5 +1,5 @@ <!-- -$PostgreSQL: pgsql/doc/src/sgml/func.sgml,v 1.263 2005/07/06 19:02:52 momjian Exp $ +$PostgreSQL: pgsql/doc/src/sgml/func.sgml,v 1.264 2005/07/10 04:54:30 momjian Exp $ PostgreSQL documentation --> @@ -1257,6 +1257,26 @@ PostgreSQL documentation </row> <row> + <entry><literal><function>regexp_replace</function>(<parameter>source</parameter> <type>text</type>, + <parameter>pattern</parameter> <type>text</type>, + <parameter>replacement</parameter> <type>text</type> + <optional>, <parameter>flags</parameter> <type>text</type></optional>)</literal></entry> + <entry><type>text</type></entry> + <entry>Replace string that matches the regular expression + <parameter>pattern</parameter> in <parameter>source</parameter> to + <parameter>replacement</parameter>. + <parameter>replacement</parameter> can use <literal>\1</>-<literal>\9</> and <literal>\&</>. + <literal>\1</>-<literal>\9</> is a back reference to the n'th subexpression, and + <literal>\&</> is the entire matched string. + <parameter>flags</parameter> can use <literal>g</>(global) and <literal>i</>(ignore case). + When flags is not specified, case sensitive matching is used, and it replaces + only the instance. + </entry> + <entry><literal>regexp_replace('1112223333', '(\\d{3})(\\d{3})(\\d{4})', '(\\1) \\2-\\3')</literal></entry> + <entry><literal>(111) 222-3333</literal></entry> + </row> + + <row> <entry><literal><function>repeat</function>(<parameter>string</parameter> <type>text</type>, <parameter>number</parameter> <type>integer</type>)</literal></entry> <entry><type>text</type></entry> <entry>Repeat <parameter>string</parameter> the specified |