The initcap function is not completely consistent with Oracle's initcap
function:

     SELECT initcap('alex hyde-whyte');

In Oracle 9.2i this will return 'Alex Hyde-White', in PostgreSQL 7.3.3
it returns 'Alex Hyde-white'.

It looks like a relatively simple change to oracle_compat.c in
backend/utils/adt, but is this a bugfix that can be made during the
pre-beta period for 7.4 or does it need to wait?
--
Mike Nolan

Wed, 9 Jul 2003 13:14:37 -0500 (CDT)
nolan@celery.tssi.com
initcap incompatibility issue
> 
> The initcap function is not completely consistent with Oracle's initcap
> function:
> 
>      SELECT initcap('alex hyde-whyte');
> 
> In Oracle 9.2i this will return 'Alex Hyde-White', in PostgreSQL 7.3.3
> it returns 'Alex Hyde-white'.

No, it doesn't change the 'y' to an 'i', that's a typo in my earlier
note.  As far as I can tell, not capitalizing the first letter after a dash
is the only inconsistency with Oracle's implementation of this function.

If a patch is in order at this time, I will try to produce it, I need to 
learn set up CVS and how to do that anyway.  :-)
--
Mike Nolan

Wed, 9 Jul 2003 13:29:06 -0500 (CDT)
nolan@celery.tssi.com
Re: initcap incompatibility issue