Re: REGEXP_REPLACE woes - Mailing list pgsql-general

From Leif B. Kristensen
Subject Re: REGEXP_REPLACE woes
Date
Msg-id 200806111224.14301.leif@solumslekt.org
Whole thread Raw
In response to Re: REGEXP_REPLACE woes  ("Leif B. Kristensen" <leif@solumslekt.org>)
List pgsql-general
On Wednesday 11. June 2008, Leif B. Kristensen wrote:

>        p := BTRIM(tmp, '#')::INTEGER;
>        name := get_person_name(p);
>        str := REPLACE(str, tmp, name);

I did some "folding" and replaced the above with

str := REPLACE(str, tmp, get_person_name(BTRIM(tmp, '#')::INTEGER));

and got rid of two variables.
--
Leif Biberg Kristensen | Registered Linux User #338009
http://solumslekt.org/ | Cruising with Gentoo/KDE
My Jazz Jukebox: http://www.last.fm/user/leifbk/

pgsql-general by date:

Previous
From: valgog
Date:
Subject: Re: "connect by"
Next
From:
Date:
Subject: Re: Insert into master table ->" 0 rows affected" -> Hibernate problems