Re: Modifying text data? - Mailing list pgsql-general

From Darren Ferguson
Subject Re: Modifying text data?
Date
Msg-id Pine.LNX.4.10.10203130939070.28896-100000@thread.crystalballinc.com
Whole thread Raw
In response to Modifying text data?  (e_arizon_benito@yahoo.com (Enrique Arizón Benito))
List pgsql-general
Check out UPPER() and LOWER() functions these will help you

i.e. upper(canada)
CANADA

i.e. lower(CAnada)
canada

i.e. initcap(canada)
Canada

HTH
Darren Ferguson

On 8 Mar 2002, [ISO-8859-1] Enrique Ariz�n 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!
>
> ---------------------------(end of broadcast)---------------------------
> TIP 6: Have you searched our list archives?
>
> http://archives.postgresql.org
>


pgsql-general by date:

Previous
From: "Dan Langille"
Date:
Subject: Re: Field Constraints
Next
From: Marcelo Pereira
Date:
Subject: Last Insert