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