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@[EMAIL PROTECTED]
On Behalf Of Kevin Grittner
Sent: Tuesday, July 01, 2008 2:23 PM
To: Naomi Walker; pgsql-admin@[EMAIL PROTECTED]
Re: [ADMIN] Change a character in a text field
>>> Naomi Walker <nwalker@[EMAIL PROTECTED]
> wrote:=20
> Is there some way with a SQL state to interrogate a text field, and=20
> replace characters.
>=20
> For example, we would like all "|"'s to be changed to something else,
on=20
> a regular basis...
=20
It sounds like you might want to look at the regexp_replace function:
=20
http://www.postgresql.org/docs/8.3/interactive/functions-matching.html#F
UNCTIONS-POSIX-REGEXP
=20
Be sure to use a WHERE clause on your UPDATE with the ~ operator.
=20
-Kevin
--=20
Sent via pgsql-admin mailing list (pgsql-admin@[EMAIL PROTECTED]
)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-admin
-- CONFIDENTIALITY NOTICE --
Information transmitted by this??e-mail is proprietary to MphasiS and/or
it=
s Customers and is intended for use only by the individual or entity to
whi=
ch it is addressed, and may contain information that is??privileged,
confid=
ential or exempt from disclosure under applicable law. If you are not the
i=
ntended recipient or it appears that this e-mail has been forwarded to you
=
without proper authority, you are notified that any use or dissemination
of=
this information in any manner is strictly prohibited. In such cases,
plea=
se notify us immediately at mailmaster@[EMAIL PROTECTED]
and delete this mail
fro=
m your records.
--=20
Sent via pgsql-admin mailing list (pgsql-admin@[EMAIL PROTECTED]
)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-admin
|
