pg.ddx.io  pgsql-sql@postgresql.org mailing list archive  
help / color / mirror / Atom feed
From: Alvaro Herrera <alvherre@commandprompt.com>
To: Shavonne Marietta Wijesinghe <shavonne.marietta@studioform.it>
Cc: Bart Degryse <Bart.Degryse@indicator.be>
Cc: pgsql-sql@postgresql.org
Subject: Re: Uppercase and Lowercase
Date: Mon, 19 Feb 2007 12:54:06 -0300
Message-ID: <20070219155406.GO28395@alvh.no-ip.org> (raw)
In-Reply-To: <002701c7543c$2a888730$1102a8c0@dream>
References: <001001c75439$b7749b50$1102a8c0@dream>
	<45D9CF8C.A3DD.0030.0@indicator.be>
	<002701c7543c$2a888730$1102a8c0@dream>

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



view thread (7+ messages)  latest in thread

Message-ID: <20070219155406.GO28395@alvh.no-ip.org>
Permalink:  ../20070219155406.GO28395@alvh.no-ip.org/
Also on:    postgresql.org/message-id/20070219155406.GO28395@alvh.no-ip.org

 · 

reply

Reply instructions:

You may reply publicly to this message via plain-text email
using any one of the following methods:

* Reply to all the recipients using the --to and --cc options:
  reply via email

  To: pgsql-sql@postgresql.org
  Cc: alvherre@commandprompt.com, shavonne.marietta@studioform.it, Bart.Degryse@indicator.be
  Subject: Re: Uppercase and Lowercase
  In-Reply-To: <20070219155406.GO28395@alvh.no-ip.org>

* Save the following mbox file, import it into your mail client,
  and reply-to-all from there: mbox

This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox