Re: Change a character in a text field

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@postgresql.org
> [mailto:pgsql-admin-owner@postgresql.org] 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 <nwalker@mhs.mphasis.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#F
> UNCTIONS-POSIX-REGEXP
>
> Be sure to use a WHERE clause on your UPDATE with the ~ operator.
>
> -Kevin
>
>