agora inbox for pgsql-docs@postgresql.org
help / color / mirror / Atom feedFrom: Jeff Davis <pgsql@j-davis.com>
To: Peter Eisentraut <peter@eisentraut.org>
To: Oleg Tselebrovskiy <o.tselebrovskiy@postgrespro.ru>
Cc: Alexander Korotkov <aekorotkov@gmail.com>
Cc: pgsql-docs@lists.postgresql.org
Subject: Re: Initcap works differently with different locale providers
Date: Wed, 06 Aug 2025 11:21:15 -0700
Message-ID: <d06df07830f2f34d3aae908bb3ed2c36b098399e.camel@j-davis.com> (raw)
In-Reply-To: <415a8ce2-7b15-4fd0-b82a-1d13aba754ed@eisentraut.org>
References: <804cc10ef95d4d3b298e76b181fd9437@postgrespro.ru>
<0658C8F0-5ED4-4962-A2A3-524B0D899982@gmail.com>
<9247c1b9531136e15d83511270e8c43bf877c9ca.camel@j-davis.com>
<cdfa64230784d7e330c1a2a55237b94e@postgrespro.ru>
<d8eacbeb8194c578a98317b86d7eb2ef0b6eb0e0.camel@j-davis.com>
<415a8ce2-7b15-4fd0-b82a-1d13aba754ed@eisentraut.org>
On Wed, 2025-08-06 at 13:44 +0200, Peter Eisentraut wrote:
> It's meant to be an Oracle-compatible function, so maybe someone can
> check there for some details.
If it's purely a compatibility function, then using ICU's sophisticated
word break iterator doesn't make sense.
> https://docs.oracle.com/en/database/oracle/oracle-database/18/sqlrf/INITCAP.html
>
> I think we should try to document the behavior more precisely.
I don't think ICU purely follows Unicode on this point (does it?), so
we'd have to point to the ICU documentation.
> But we
> probably first have to agree what it should be.
I still don't fully understand the use case here. I've used the
function a few times to assemble a few strings into a page heading, but
that was some time ago so I don't even clearly remember my use case. It
seems plausible there are quite a few people doing something similar,
and they'd benefit from ICU's more sophisticated approach.
But if the primary use case is for compatibility, then we might be
trying to hard to make this a provider-specific feature.
>
> Yes, I was not in favor of backpatching this, since it was not a bug
> fix. And it turns out it was incomplete. I think we should revert
> all
> the backpatches and iterate on getting the documentation the way we
> want
> in master.
+1.
Regards,
Jeff Davis
view thread (16+ messages) latest in thread
Message-ID: <d06df07830f2f34d3aae908bb3ed2c36b098399e.camel@j-davis.com>
Permalink: ../d06df07830f2f34d3aae908bb3ed2c36b098399e.camel@j-davis.com/
Also on: postgresql.org/message-id/d06df07830f2f34d3aae908bb3ed2c36b098399e.camel@j-davis.com
reply
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-docs@postgresql.org
Cc: pgsql@j-davis.com, peter@eisentraut.org, o.tselebrovskiy@postgrespro.ru, aekorotkov@gmail.com, pgsql-docs@lists.postgresql.org
Subject: Re: Initcap works differently with different locale providers
In-Reply-To: <d06df07830f2f34d3aae908bb3ed2c36b098399e.camel@j-davis.com>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by agora; see mirroring instructions
for how to clone and mirror all data and code used for this inbox