Postgres Pro
Downloads
Home   >   mailing lists

Re: Uppercase and Lowercase - Mailing list pgsql-sql

From Bart Degryse
Subject Re: Uppercase and Lowercase
Date
Msg-id 45D9CF8C.A3DD.0030.0@indicator.be
Whole thread Raw
In response to Uppercase and Lowercase  ("Shavonne Marietta Wijesinghe" <shavonne.marietta@studioform.it>)
List pgsql-sql
Tree view
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

pgsql-sql by date:

Previous
From: "Shavonne Marietta Wijesinghe"
Date:
Subject: Uppercase and Lowercase
Next
From: Andrew Sullivan
Date:
Subject: Re: Uppercase and Lowercase