Thread: initcap() whitespace bug
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
"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
I wrote: > 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. Actually, someone already fixed the documentation in CVS tip: see http://developer.postgresql.org/docs/postgres/functions-string.html regards, tom lane