Re: REGEXP_REPLACE woes

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