Re: Initcap works differently with different locale providers - Mailing list pgsql-docs

From Jeff Davis
Subject Re: Initcap works differently with different locale providers
Date
Msg-id d8eacbeb8194c578a98317b86d7eb2ef0b6eb0e0.camel@j-davis.com
Whole thread Raw
In response to Re: Initcap works differently with different locale providers  (Oleg Tselebrovskiy <o.tselebrovskiy@postgrespro.ru>)
Responses Re: Initcap works differently with different locale providers
List pgsql-docs
On Mon, 2025-08-04 at 12:30 +0700, Oleg Tselebrovskiy wrote:
> First patch just adds this warning about not relying on initcap()
> exact
> result. The second one is the same, but removes the part "what is a
> word"
> since it's could be moot because we recommend writing custom
> functions,
> so understanding what is a word is not exactly needed. Still on the
> fence
> about which patch is better, though

One more thing: we should also change it to "... to  upper case (or
title case) and the rest to lower case...". Title case is for scripts
that have characters like 'Dž' (U+01C5).

Other than that I like the second version, which un-documents the
specific word boundary rules. I'll admit I'm not quite sure how people
use this function in practice, but I expect that it's mostly convenient
(or lazy) display.

Alexander, is there a reason you backported this change? I don't
normally backport doc improvements like this, but I'm not sure what
standard others use. The fact that it's on 7 branches makes me more
reluctant to commit these extra improvements on top. Can you take care
of these follow-up patches? Or, just revert the change and I can make
the improvements in master.

Regards,
    Jeff Davis




pgsql-docs by date:

Previous
From: Shuyu Pan
Date:
Subject: Re: further clarification: alter table alter column set not null - table scan is skipped
Next
From: Oleg Tselebrovskiy
Date:
Subject: Re: Initcap works differently with different locale providers