Karen Stone wrote:
Can you please provide a complete example of how to use this in the
update command? ie... how do we select the table/field that we want to
interrogate and make the change to?
Thanks!
Karen Stone
Technical Services
MphasiS Health Solutions
602.604.3100 x265
-----Original Message-----
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED] On Behalf Of Kevin Grittner
Sent: Tuesday, July 01, 2008 2:23 PM
To: Naomi Walker; pgsql-admin@postgresql.org
Subject: Re: [ADMIN] Change a character in a text field
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#F
UNCTIONS-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
