From: Gary Chambers <gwchamb@gmail.com>
To: Michael Gould <mgould@intermodalsoftwaresolutions.net>
Cc: pgsql-sql@postgresql.org
Subject: Re: Proper case function
Date: Thu, 31 Dec 2009 12:40:35 -0500
Message-ID: <302670f20912310940v2307bd0ey368815943615d37e@mail.gmail.com> (raw)
In-Reply-To: <fce1331ff892331117131ba9a20dd949@intermodalsoftwaresolutions.net>
References: <df8d2df50912310823p1d2e3fdu6496571484360be1@mail.gmail.com>
<fce1331ff892331117131ba9a20dd949@intermodalsoftwaresolutions.net>
> Has anyone got a proper case function that they are willing to share. We're
> moving from SQL Anywhere to PostgreSQL and decided that much of our data is
> upper case when it really should be proper cased. The columns that we will
> be putting proper case data in are all defined using the contrib module
> citext which makes searching very nice.
Why doesn't the initcap function work as you require?
-- Gary Chambers
/* Nothing fancy and nothing Microsoft! */
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: gwchamb@gmail.com, mgould@intermodalsoftwaresolutions.net
Subject: Re: Proper case function
In-Reply-To: <302670f20912310940v2307bd0ey368815943615d37e@mail.gmail.com>
* 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