Re: initcap incompatibility issue

From: "scott(dot)marlowe" <scott(dot)marlowe(at)ihs(dot)com>
To: nolan <nolan(at)celery(dot)tssi(dot)com>
Cc: pgsql hackers list <pgsql-hackers(at)postgresql(dot)org>
Subject: Re: initcap incompatibility issue
Date: 2003-07-09 19:42:50
Message-ID: Pine.LNX.4.33.0307091341540.8918-100000@css120.ihs.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

On Wed, 9 Jul 2003 nolan(at)celery(dot)tssi(dot)com wrote:

> > 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.
>
> Wrong again. Oracle also capitalizes the first letter after a comma,
> semicolon, colon, period, and both a single and double quote. (And that's
> all I've tested so far.)
>
> So, I guess I need to write a program to test all possible combinations
> to see how incompatible the function is.
>
> Making this change will be a larger patch than I had initially anticipated.
>
> That also brings into question whether this is really a bugfix or a
> specification change, a question which is relevant since we're in the
> feature freeze for 7.4.

It sounds like Oracle is simply regexing for anything that ISN'T a letter
to initcap right after it. If that's the case, you could just regex too.

In response to

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Bruce Momjian 2003-07-09 20:39:10 Beta start date
Previous Message nolan 2003-07-09 18:44:44 Re: initcap incompatibility issue