On Thu, 17 Aug 2006, Dan Franklin wrote:
> Date: Thu, 17 Aug 2006 15:34:41 -0400
> From: Dan Franklin <dfranklin@fen.com>
> To: tomas@tuxteam.de
> Cc: pgsql-bugs@postgresql.org
> Subject: Re: [BUGS] BUG #2579: initcap should not capitalize letter
>
> Good point. It is probably not possible to get
> it perfect. But I think that possessives and
> contractions occur more often in a typical body
> of text than Irish names. So it would be right
> more often, even if it is still wrong some of the time.
>
> Dan Franklin
Two thoughts:
1) In English at least, it's only at the trailing end of a word that the
non-capitalization is clear (contractions, possessive, etc).
2) Proper names are unknowable as to what's appropriate and I posit that
there is no algorithm that works for names.
This leads to a conclusion: Never add capitalization inside a string of
letters.
Rgds,
Richard
>
> At 03:08 PM 8/17/2006, tomas@tuxteam.de wrote:
> >-----BEGIN PGP SIGNED MESSAGE-----
> >Hash: SHA1
> >
> >On Wed, Aug 16, 2006 at 09:03:08PM +0000, Dan Franklin wrote:
> > >
> > > The following bug has been logged online:
> > >
> > > Bug reference: 2579
> > > Logged by: Dan Franklin
> > > Email address: dfranklin@fen.com
> > > PostgreSQL version: 8.1.4
> > > Operating system: GNU/Linux Fedora Core 5
> > > Description: initcap should not capitalize letter after apostrophe
> > > Details:
> > >
> > > The statement
> > > select initcap('John''s Parents');
> > > returns
> > > John'S Parents
> > >
> > > The capital "S" after the apostrophe is incorrect. initcap should consider
> > > the apostrophe to be a word-constituent for the purpose of identifying word
> > > boundaries at which to start capitalizing.
> >
> >Hmm. And what about Flann O'Brien?
> >
> >Tough thing, this.
> >
> >Regards
> >- -- tomás
> >-----BEGIN PGP SIGNATURE-----
> >Version: GnuPG v1.4.1 (GNU/Linux)
> >
> >iD8DBQFE5L60Bcgs9XrR2kYRArkQAKCBI9uYSUckPWL6jzB3PFBXNAlwSgCeOoJx
> >NIBRgQZYqRajtx8HrUnW1Hs=
> >=GI/E
> >-----END PGP SIGNATURE-----
>
> Dan Franklin
> Family Education Network
> Pearson Education
> 617-671-3799
>
>
>
> ---------------------------(end of broadcast)---------------------------
> TIP 9: In versions below 8.0, the planner will ignore your desire to
> choose an index scan if your joining column's datatypes do not
> match
>
--
Richard Troy, Chief Scientist
Science Tools Corporation
510-924-1363 or 202-747-1263
rtroy@ScienceTools.com, http://ScienceTools.com/