Re: REGEXP_REPLACE woes - Mailing list pgsql-general

From Michael Fuhr
Subject Re: REGEXP_REPLACE woes
Date
Msg-id 20080610134153.GB1944@winnie.fuhr.org
Whole thread Raw
In response to Re: REGEXP_REPLACE woes  ("Leif B. Kristensen" <leif@solumslekt.org>)
Responses Re: REGEXP_REPLACE woes
List pgsql-general
On Tue, Jun 10, 2008 at 02:59:53PM +0200, Leif B. Kristensen wrote:
> So far, so good. But look here:
>
> pgslekt=> select link_expand('[p=123|John Smith] and [p=456|Jane Doe]');
>                               link_expand
> -----------------------------------------------------------------------
>  <a href="./family.php?person=123">John Smith] and [p=456|Jane Doe</a>
> (1 row)
>
> Hey, I told it not to be greedy, didn't I?

Yes, but regexp_replace only replaces that part of the original
string that matches the regular expression -- the rest it leaves
alone.

--
Michael Fuhr

pgsql-general by date:

Previous
From: Michael Fuhr
Date:
Subject: Re: REGEXP_REPLACE woes
Next
From: "Leif B. Kristensen"
Date:
Subject: Re: REGEXP_REPLACE woes