| From: | Stephan Szabo <sszabo(at)megazone23(dot)bigpanda(dot)com> |
|---|---|
| To: | Enrique Arizón Benito <e_arizon_benito(at)yahoo(dot)com> |
| Cc: | <pgsql-general(at)postgresql(dot)org> |
| Subject: | Re: Modifying text data? |
| Date: | 2002-03-13 16:23:22 |
| Message-ID: | 20020313082255.I81426-100000@megazone23.bigpanda.com |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
On 8 Mar 2002, [ISO-8859-1] Enrique Arizn Benito wrote:
> Hi,
> I'm trying to modify text fields in an "automatic" way so to be able
> for example, to change any 'Canada' substring occurrence with the
> UPPER CASE equivalent "CANADA", with the added option 'Canada'
> appearing anywhere inside the text field.
> While it is very easy to find matching registers by using regular
> expresions, (SELECT * from my_table where my_columm ~* 'canada'; in
> previous example) I find no way to change them afterwards, but
> manually updating each register.
>
> Thanks in advance for any suggestions!
You might want to look into pl/perl, soundslike something that'd be easy
to do there.
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Jean-Michel POURE | 2002-03-13 16:39:40 | Re: Stored procedure in PostgreSQL |
| Previous Message | Stephan Szabo | 2002-03-13 16:20:51 | Re: Referential integrity violation |