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 -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general