Re: initcap incompatibility issue - Mailing list pgsql-hackers

From scott.marlowe
Subject Re: initcap incompatibility issue
Date
Msg-id Pine.LNX.4.33.0307091341540.8918-100000@css120.ihs.com
Whole thread Raw
In response to Re: initcap incompatibility issue  (nolan@celery.tssi.com)
Responses Re: initcap incompatibility issue  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-hackers
On Wed, 9 Jul 2003 nolan@celery.tssi.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.



pgsql-hackers by date:

Previous
From: nolan@celery.tssi.com
Date:
Subject: Re: initcap incompatibility issue
Next
From: Bruce Momjian
Date:
Subject: Beta start date