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
At 03:08 PM 8/17/2006, [EMAIL PROTECTED] 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: [EMAIL PROTECTED]
> 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
