Received: from maia.hub.org (unknown [200.46.204.183]) by mail.postgresql.org (Postfix) with ESMTP id A25736344DC for ; Wed, 6 Jan 2010 13:41:31 -0400 (AST) Received: from mail.postgresql.org ([200.46.204.86]) by maia.hub.org (mx1.hub.org [200.46.204.183]) (amavisd-maia, port 10024) with ESMTP id 91221-03-2 for ; Wed, 6 Jan 2010 17:41:21 +0000 (UTC) X-Greylist: delayed 00:21:12.079927 by SQLgrey-1.7.6 Received: from js.id.au (dsl-58-6-192-22.wa.westnet.com.au [58.6.192.22]) by mail.postgresql.org (Postfix) with ESMTP id 64847638AF1 for ; Wed, 6 Jan 2010 12:03:27 -0400 (AST) Received: from ns.demo.lan (unknown [192.168.4.10]) by js.id.au (Postfix) with ESMTP id 5DCF03B0003 for ; Wed, 6 Jan 2010 23:42:09 +0800 (WST) Received: from bobtail.demo.lan (Bobtail.demo.lan [192.168.9.109]) by ns.demo.lan (Postfix) with ESMTP id 92DDDC2C016 for ; Wed, 6 Jan 2010 23:42:09 +0800 (WST) Message-ID: <4B44AF51.80709@herakles.homelinux.org> Date: Wed, 06 Jan 2010 23:42:09 +0800 From: John Summerfield User-Agent: Mozilla/5.0 (X11; U; Linux x86_64; en-US; rv:1.8.1.19) Gecko/20090222 SeaMonkey/1.1.14 MIME-Version: 1.0 To: pgsql-sql@postgresql.org Subject: Re: Proper case function References: In-Reply-To: Content-Type: text/plain; charset=UTF-8; format=flowed Content-Transfer-Encoding: 7bit X-Virus-Scanned: Maia Mailguard 1.0.1 X-Spam-Status: No, hits=3.289 tagged_above=-10 required=5 tests=BAYES_50=0.001, FH_DATE_PAST_20XX=3.188, RDNS_DYNAMIC=0.1 X-Spam-Level: *** X-Archive-Number: 201001/5 X-Sequence-Number: 33541 Michael Gould 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 I've looked at rationalising names in this manner before, and found that, depending on the individual, both Macdonald and Macdonald are correct. So I waved my hands around, harrumphed and went for Macdonald in all cases. I'm sure that should the MacDonalds have not become accustomed to being recorded as Macdonalds, surely they will soon, or at least not complain about it. --