From: Shavonne Marietta Wijesinghe <shavonne.marietta@studioform.it>
To: Bart Degryse <Bart.Degryse@indicator.be>
To: pgsql-sql@postgresql.org
Subject: Re: Uppercase and Lowercase
Date: Mon, 19 Feb 2007 16:39:38 +0100
Message-ID: <002701c7543c$2a888730$1102a8c0@dream> (raw)
References: <001001c75439$b7749b50$1102a8c0@dream>
<45D9CF8C.A3DD.0030.0@indicator.be>
Hey thanks Bart. it worked ;)
but sadly what it does is changes "VIA SENATO" in to "Via senato" but what i need is "Via Senato"
Anyoneeeeeee??
Shavonne Wijesinghe
----- Original Message -----
From: Bart Degryse
To: pgsql-sql@postgresql.org
Sent: Monday, February 19, 2007 4:25 PM
Subject: Re: [SQL] Uppercase and Lowercase
Replace && by ||
>>> "Shavonne Marietta Wijesinghe" <shavonne.marietta@studioform.it> 2007-02-19 16:22 >>>
Hello
In my PostgreSQL database i have records inserted in Uppercase.
For example: VIA SENATO
What i want is to change them to "Via Senato". Ofcourse i'm looking for a automatico way. I wrote this code update registro1 set pa_indirizzo = upper(substr(pa_indirizzo, 1, 1)) && lower(substr(pa_indirizzo, 2, length(pa_indirizzo) - 1)) But it doesn't work.
When i run only update registro1 set pa_indirizzo = upper(substr(pa_indirizzo, 1, 1)) It gets me the first letter and when i run
update registro1 set pa_indirizzo = lower(substr(pa_indirizzo, 2, length(pa_indirizzo) - 1)) I get from the second letter to the last. But when i join them them don't work..
Anyone got any idea??
Thanks
Shavonne Wijesinghe
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-sql@postgresql.org
Cc: shavonne.marietta@studioform.it, Bart.Degryse@indicator.be
Subject: Re: Uppercase and Lowercase
In-Reply-To: <002701c7543c$2a888730$1102a8c0@dream>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox