>>> Naomi Walker <nwalker(at)mhs(dot)mphasis(dot)com> wrote:
> Is there some way with a SQL state to interrogate a text field, and
> replace characters.
>
> For example, we would like all "|"'s to be changed to something else,
on
> a regular basis...
It sounds like you might want to look at the regexp_replace function:
http://www.postgresql.org/docs/8.3/interactive/functions-matching.html#FUNCTIONS-POSIX-REGEXP
Be sure to use a WHERE clause on your UPDATE with the ~ operator.
-Kevin