initcap() whitespace bug

From: "Darrell Walisser" <dwalisser(at)mediak(dot)com>
To: <pgsql-bugs(at)postgresql(dot)org>
Subject: initcap() whitespace bug
Date: 2004-11-30 17:30:29
Message-ID: 006101c4d702$49e41f90$0402a8c0@DARRELL
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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

Responses

Browse pgsql-bugs by date

  From Date Subject
Next Message Shahbaz Javeed 2004-11-30 18:17:17 Re: Backend with closed connection at 99% CPU
Previous Message Tom Lane 2004-11-30 16:53:09 Re: Out of memory while UPDATE some_table ... FROM some_view (8.0 beta5)