Richard Troy wrote: > > > On Thu, 17 Aug 2006, Dan Franklin wrote: > > > Date: Thu, 17 Aug 2006 15:34:41 -0400 > > From: Dan Franklin <[EMAIL PROTECTED]> > > To: [EMAIL PROTECTED] > > 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.
Interesting, but it worth breaking Oracle compatibility for it? -- Bruce Momjian [EMAIL PROTECTED] EnterpriseDB http://www.enterprisedb.com + If your life is a hard drive, Christ can be your backup. + ---------------------------(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