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: pgsql-admin-owner@xxxxxxxxxxxxxx
[mailto:pgsql-admin-owner@xxxxxxxxxxxxxx] On Behalf Of Kevin Grittner
Sent: Tuesday, July 01, 2008 2:23 PM
To: Naomi Walker; pgsql-admin@xxxxxxxxxxxxxx
Subject: Re: [ADMIN] Change a character in a text field
Naomi Walker <nwalker@xxxxxxxxxxxxxxx> 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
