replace text function

From: "Mark Wilson" <mark(at)mediasculpt(dot)com>
To: <pgsql-general(at)postgresql(dot)org>
Subject: replace text function
Date: 2002-11-06 22:20:51
Message-ID: 046c01c285e2$c74b0200$3301a8c0@merl
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Joe Conway 2002-11-06 22:51:25 Re: replace text function
Previous Message scott.marlowe 2002-11-06 20:38:06 Re: Stability problems