Uppercase and Lowercase
| От | Shavonne Marietta Wijesinghe |
|---|---|
| Тема | Uppercase and Lowercase |
| Дата | |
| Msg-id | 001001c75439$b7749b50$1102a8c0@dream обсуждение исходный текст |
| Ответы |
Re: Uppercase and Lowercase
Re: Uppercase and Lowercase |
| Список | pgsql-sql |
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
В списке pgsql-sql по дате отправления: