replace text function - Mailing 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