From: | "Shavonne Marietta Wijesinghe" <shavonne(dot)marietta(at)studioform(dot)it> |
---|---|
To: | "Bart Degryse" <Bart(dot)Degryse(at)indicator(dot)be>, <pgsql-sql(at)postgresql(dot)org> |
Subject: | Re: Uppercase and Lowercase |
Date: | 2007-02-19 15:39:38 |
Message-ID: | 002701c7543c$2a888730$1102a8c0@dream |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-sql |
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(at)postgresql(dot)org
Sent: Monday, February 19, 2007 4:25 PM
Subject: Re: [SQL] Uppercase and Lowercase
Replace && by ||
>>> "Shavonne Marietta Wijesinghe" <shavonne(dot)marietta(at)studioform(dot)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
From | Date | Subject | |
---|---|---|---|
Next Message | Bart Degryse | 2007-02-19 15:48:41 | Re: Uppercase and Lowercase |
Previous Message | Andrew Sullivan | 2007-02-19 15:30:19 | Re: Uppercase and Lowercase |