From: Jasen Betts <jasen@xnet.co.nz>
To: pgsql-sql@postgresql.org
Subject: Re: Proper case function
Date: 1 Jan 2010 10:39:23 GMT
Message-ID: <hhkjcr$fmk$1@reversiblemaps.ath.cx> (raw)
References: <302670f20912310940v2307bd0ey368815943615d37e@mail.gmail.com>
<b438f326e635060f808c7af513f0653c@intermodalsoftwaresolutions.net>
On 2009-12-31, Michael Gould <mgould@intermodalsoftwaresolutions.net> wrote:
> Gary,
>
> Based on what I read it wouldn't handle cases where the result should be
>
> MacDonald from macdonald. There are other cases such as the sentence below
>
> ('it''s crazy! i couldn''t believe kate mcdonald, leo dicaprio, (terrence)
> trent d''arby (circa the 80''s), and jada pinkett-smith all showed up to
> [cHris o''donnell''s] party...donning l''oreal lIpstick! They''re heading to
> o''neil''s pub later on t''nite. the_underscore_test. the-hyphen-test)
>
> This wouldn't handle the quotes and proper case all of the words.
There is no case-restoring algorithm that works in all cases.
Some people case their name differently just as some spell their name
differently. Possibly for the same reasons.
Contact the owners of the names and offer them the opportunity to have
their name represented in the correct case - send them a link to an online
form.
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: jasen@xnet.co.nz
Subject: Re: Proper case function
In-Reply-To: <hhkjcr$fmk$1@reversiblemaps.ath.cx>
* 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