Re: initcap() whitespace bug - Mailing list pgsql-bugs

From Tom Lane
Subject Re: initcap() whitespace bug
Date
Msg-id 24503.1101848650@sss.pgh.pa.us
Whole thread Raw
In response to initcap() whitespace bug  ("Darrell Walisser" <dwalisser@mediak.com>)
Responses Re: initcap() whitespace bug  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-bugs
"Darrell Walisser" <dwalisser@mediak.com> writes:
> It appears that "'" is being considered as a whitespace (and perhaps other
> punctuation, haven't checked myself):

Hmm.  The documentation is at variance with the code, which clearly says

 *     Returns string, with first letter of each word in uppercase, all
 *     other letters in lowercase. A word is defined as a sequence of
 *     alphanumeric characters, delimited by non-alphanumeric
 *     characters.

and indeed implements it that way.

It looks like we changed the code to match what Oracle does on
7/27/2003, but forgot to fix the documentation.  Will fix, thanks
for the report.

            regards, tom lane

pgsql-bugs by date:

Previous
From: "Darrell Walisser"
Date:
Subject: initcap() whitespace bug
Next
From: Tom Lane
Date:
Subject: Re: initcap() whitespace bug