initcap() whitespace bug - Mailing list pgsql-bugs

From Darrell Walisser
Subject initcap() whitespace bug
Date
Msg-id 006101c4d702$49e41f90$0402a8c0@DARRELL
Whole thread Raw
Responses Re: initcap() whitespace bug
List pgsql-bugs
It appears that "'" is being considered as a whitespace (and perhaps other
punctuation, haven't checked myself):

initcap(text) " Convert first letter of each word (whitespace-separated) to
upper case "

Sample SQL: select initcap('grahm''s little angel');

Incorrect Result (Note capital S): 'Grahm'S Little Angel'

Postgresql Version: 7.4.5

pgsql-bugs by date:

Previous
From: Bruce Momjian
Date:
Subject: Re: BUG #1319: Windows LIB file libecpg.lib not in build or package
Next
From: Tom Lane
Date:
Subject: Re: initcap() whitespace bug