Re: Uppercase and Lowercase

From: Andrew Sullivan <ajs(at)crankycanuck(dot)ca>
To: pgsql-sql(at)postgresql(dot)org
Subject: Re: Uppercase and Lowercase
Date: 2007-02-19 15:30:19
Message-ID: 20070219153019.GB8840@phlogiston.dyndns.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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(at)crankycanuck(dot)ca
If they don't do anything, we don't need their acronym.
--Josh Hamilton, on the US FEMA

In response to

Browse pgsql-sql by date

  From Date Subject
Next Message Shavonne Marietta Wijesinghe 2007-02-19 15:39:38 Re: Uppercase and Lowercase
Previous Message Bart Degryse 2007-02-19 15:25:48 Re: Uppercase and Lowercase