From: | "Jacob Vennervald Madsen" <jvm(at)gopinocchio(dot)com> |
---|---|
To: | Enrique Arizón Benito <e_arizon_benito(at)yahoo(dot)com>, <pgsql-general(at)postgresql(dot)org> |
Subject: | Re: Modifying text data? |
Date: | 2002-03-13 15:39:14 |
Message-ID: | EB0B5D39043C344BA53B0F4AB15AE63302995B@gop-server.GOP-server.local |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
I would guess you will have to make a stored procedure to handle that.
Jacob Vennervald
> -----Original Message-----
> From: Enrique Arizón Benito [mailto:e_arizon_benito(at)yahoo(dot)com]
> Sent: 8. marts 2002 11:48
> To: pgsql-general(at)postgresql(dot)org
> Subject: [GENERAL] Modifying text data?
>
>
> 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!
>
> ---------------------------(end of
> broadcast)---------------------------
> TIP 6: Have you searched our list archives?
>
> http://archives.postgresql.org
>
From | Date | Subject | |
---|---|---|---|
Next Message | Doug McNaught | 2002-03-13 15:40:25 | Re: vacuum with perl dbi / pg 7.1.3 |
Previous Message | Doug McNaught | 2002-03-13 15:33:16 | Re: Export a database or a table from a database |