Skip site navigation (1) Skip section navigation (2)

Re: regexp_replace

From: Andrew Dunstan <andrew(at)dunslane(dot)net>
To: Atsushi Ogawa <a_ogawa(at)hi-ho(dot)ne(dot)jp>
Cc: pgsql-patches(at)postgresql(dot)org
Subject: Re: regexp_replace
Date: 2005-06-27 13:49:54
Message-ID: (view raw, whole thread or download thread mbox)
Lists: pgsql-patches
I'm very glad to see this. But is a nicer name possible? To perl
programmers at least, "substitute" should make sense.



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.
>--- Atsushi Ogawa
>---------------------------(end of broadcast)---------------------------
>TIP 4: Don't 'kill -9' the postmaster

In response to


pgsql-patches by date

Next:From: Tom LaneDate: 2005-06-27 13:51:02
Subject: Re: limiting connections per user/database
Previous:From: Karel ZakDate: 2005-06-27 13:48:54
Subject: Re: Implementing SELECT FOR UPDATE [NOWAIT]

Privacy Policy | About PostgreSQL
Copyright © 1996-2017 The PostgreSQL Global Development Group