On Thu, 2023-11-30 at 21:08 -0500, Jeff Gerbracht wrote:
> It would be great if there was a way to set exceptions to the 'word' delimiter list used in
> the INITCAP() function. For example, I have hyphenated words like blue-green or
> possessives and contractions like don't and cat's tail
> These become Blue-Green, Don'T and Cat'S Tail.
>
> Being able to pass in a set of delimiter exceptions like hyphen and single quote would make
> this function much more useful for our specific use cases.
That would pretty quickly drift into locale-dependent rules. Such a function would be even
more special-case than the current "initcap()", which is already pretty specific to certain
languages. I don't know if there is enough value for the general public in it.
But it should be easy to implement it yourself, for example in PL/pgSQL. Why don't you
try that?
Yours,
Laurenz Albe