>>> Naomi Walker <[EMAIL PROTECTED]> 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
-- Sent via pgsql-admin mailing list (pgsql-admin@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-admin
