thread-index: AcjbvSlc3oDpPmReSAmrUhxs2aNOgw==
Content-Class: urn:content-classes:message
From: Naomi Walker <nwalker@mhs.mphasis.com>
To: "pgsql-admin@postgresql.org" <pgsql-admin@postgresql.org>
Subject: Change a character in a text field
Date: Tue, 1 Jul 2008 13:58:06 -0700
Message-ID: <486A9A5E.9070905@mhs.mphasis.com>
Mime-Version: 1.0
Content-Type: text/plain; charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable

Is there some way with a SQL state to interrogate a text field, and=20
replace characters.

For example, we would like all "|"'s to be changed to something else, on=20
a regular basis...
We could unload the rows, change them, and load back, but was hoping=20
someone had
a slicker way to do it in place..

Thanks,
Naomi

--=20
------------------------------------------------------------------------
Naomi Walker                          Chief Information Officer
Eldorado Computing, Inc               nwalker@eldocomp.com
=20 ---An EDS Company                   602-604-3100
------------------------------------------------------------------------
The more I want to get something done, the less I call it work.
=20  - Richard Bach
------------------------------------------------------------------------

-- CONFIDENTIALITY NOTICE --

Information transmitted by this=C2=A0e-mail is proprietary to MphasiS and/or=
 its Customers and is intended for use only by the individual or entity to w=
hich it is addressed, and may contain information that is=C2=A0privileged, c=
onfidential or exempt from disclosure under applicable law. If you are not t=
he intended recipient or it appears that this e-mail has been forwarded to y=
ou without proper authority, you are notified that any use or dissemination =
of this information in any manner is strictly prohibited. In such cases, ple=
ase notify us immediately at mailmaster@mphasis.com and delete this mail fro=
m your records.