Received: from localhost (unknown [200.46.208.211]) by mail.postgresql.org (Postfix) with ESMTP id 59176632984 for ; Thu, 31 Dec 2009 15:28:23 -0400 (AST) Received: from mail.postgresql.org ([200.46.204.86]) by localhost (mx1.hub.org [200.46.208.211]) (amavisd-maia, port 10024) with ESMTP id 09804-09 for ; Thu, 31 Dec 2009 19:28:10 +0000 (UTC) X-Greylist: domain auto-whitelisted by SQLgrey-1.7.6 Received: from lo.gmane.org (lo.gmane.org [80.91.229.12]) by mail.postgresql.org (Postfix) with ESMTP id B64CC632CE1 for ; Thu, 31 Dec 2009 15:28:12 -0400 (AST) Received: from list by lo.gmane.org with local (Exim 4.50) id 1NQQgs-0000ih-8V for pgsql-sql@postgresql.org; Thu, 31 Dec 2009 20:28:10 +0100 Received: from e177148036.adsl.alicedsl.de ([85.177.148.36]) by main.gmane.org with esmtp (Gmexim 0.1 (Debian)) id 1AlnuQ-0007hv-00 for ; Thu, 31 Dec 2009 20:28:10 +0100 Received: from tim by e177148036.adsl.alicedsl.de with local (Gmexim 0.1 (Debian)) id 1AlnuQ-0007hv-00 for ; Thu, 31 Dec 2009 20:28:10 +0100 X-Injected-Via-Gmane: http://gmane.org/ Mail-Followup-To: pgsql-sql@postgresql.org To: pgsql-sql@postgresql.org From: Tim Landscheidt Subject: Re: Proper case function Date: Thu, 31 Dec 2009 19:27:47 +0000 Organization: Lines: 18 Message-ID: References: <302670f20912310940v2307bd0ey368815943615d37e@mail.gmail.com> Mime-Version: 1.0 Content-Type: text/plain; charset=us-ascii X-Complaints-To: usenet@ger.gmane.org X-Gmane-NNTP-Posting-Host: e177148036.adsl.alicedsl.de Mail-Copies-To: never User-Agent: Gnus/5.13 (Gnus v5.13) Emacs/23.1 (gnu/linux) Cancel-Lock: sha1:6X2v6fAd82ICeeYJnpxrZHvy2eQ= X-Virus-Scanned: Maia Mailguard 1.0.1 X-Spam-Status: No, hits=-2.599 tagged_above=-10 required=5 tests=AWL=0.000, BAYES_00=-2.599 X-Spam-Level: X-Archive-Number: 200912/97 X-Sequence-Number: 33535 Michael Gould wrote: > 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. > [...] Based on your requirements, you want to hire some cheap Eng- lish native speaker with lots of cultural knowledge. Tim