Re: Uppercase and Lowercase - Mailing list pgsql-sql

From Andrew Sullivan
Subject Re: Uppercase and Lowercase
Date
Msg-id 20070219153019.GB8840@phlogiston.dyndns.org
Whole thread Raw
In response to Uppercase and Lowercase  ("Shavonne Marietta Wijesinghe" <shavonne.marietta@studioform.it>)
List pgsql-sql

On Mon, Feb 19, 2007 at 04:22:06PM +0100, Shavonne Marietta Wijesinghe wrote:
> 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". 

Have a look at the initcap() function.

A


-- 
Andrew Sullivan  | ajs@crankycanuck.ca
If they don't do anything, we don't need their acronym.    --Josh Hamilton, on the US FEMA


pgsql-sql by date:

Previous
From: "Bart Degryse"
Date:
Subject: Re: Uppercase and Lowercase
Next
From: "Shavonne Marietta Wijesinghe"
Date:
Subject: Re: Uppercase and Lowercase