>From the manual:
replace(string text, from text, to text) text Replace all occurrences
in string of substring from with substring to replace('abcdefabcdef', 'cd',
'XX') abXXefabXXef
HTH.
George
- Original Message -
From: "HR" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Mo
Maybe you want to look here:
http://www.brasileiro.net/postgres/cookbook/
mimic oracle's replace function. versions in pltcl
and plpgsql.
If the function you want isn't built in to
posgresql...
Ted
--- HR <[EMAIL PROTECTED]> wrote:
> Hi
>
> I have some URLs in a database but some of the URL
