Re: BUG #2579: initcap should not capitalize letter

Dan Franklin wrote:
> 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.
>

The function came from Oracle. How does Oracle's initcap() handle this?

---------------------------------------------------------------------------

> Dan Franklin
>
> At 03:08 PM 8/17/2006, tomas(at)tuxteam(dot)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(at)fen(dot)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

--
Bruce Momjian bruce(at)momjian(dot)us
EnterpriseDB http://www.enterprisedb.com

+ If your life is a hard drive, Christ can be your backup. +