replace text function - Mailing list pgsql-general

From Mark Wilson
Subject replace text function
Date
Msg-id 046c01c285e2$c74b0200$3301a8c0@merl
Whole thread Raw
In response to Re: i have got an error  ("scott.marlowe" <scott.marlowe@ihs.com>)
Responses Re: replace text function  (Darren Ferguson <darren@crystalballinc.com>)
List pgsql-general
Hi all,

I'm trying to find a function that will replace one word with another in a
string.

e.g. select <replace function>('bob was here, bobina wasnt', 'bob', 'mike');
will return "mike was here, mikeina wasnt"

Is there such a function already written in PostGreSQL?

Thanks in advance,
Mark


pgsql-general by date:

Previous
From: "scott.marlowe"
Date:
Subject: Re: i have got an error
Next
From: Joe Conway
Date:
Subject: Re: replace text function