Re: Uppercase and Lowercase

From: Alvaro Herrera <alvherre(at)commandprompt(dot)com>
To: Shavonne Marietta Wijesinghe <shavonne(dot)marietta(at)studioform(dot)it>
Cc: 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:54:06
Message-ID: 20070219155406.GO28395@alvh.no-ip.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-sql

Shavonne Marietta Wijesinghe wrote:
> 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??

initcap() does what you want.

--
Alvaro Herrera http://www.CommandPrompt.com/
PostgreSQL Replication, Consulting, Custom Development, 24x7 support

In response to

Browse pgsql-sql by date

  From Date Subject
Next Message Bart Degryse 2007-02-19 16:05:03 Re: Uppercase and Lowercase
Previous Message Bart Degryse 2007-02-19 15:48:41 Re: Uppercase and Lowercase