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@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

--
  Bruce Momjian   bruce@momjian.us
  EnterpriseDB    http://www.enterprisedb.com

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