Postgres Pro
Downloads
Home   >   mailing lists

BUG #2579: initcap should not capitalize letter after apostrophe - Mailing list pgsql-bugs

From Dan Franklin
Subject BUG #2579: initcap should not capitalize letter after apostrophe
Date
Msg-id 200608162103.k7GL38li071530@wwwmaster.postgresql.org
Whole thread Raw
Responses Re: BUG #2579: initcap should not capitalize letter after apostrophe  (tomas@tuxteam.de)
List pgsql-bugs
Tree view 
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.

pgsql-bugs by date:

Previous
From: "Anita Lederer"
Date:
Subject: Re: out of memory
Next
From: "Alex Zhang"
Date:
Subject: BUG #2580: Analyze table cause invalid memory alloc error in "start with xx" select statement