> On Mar 15, 2025, at 10:22 AM, Jeff Davis <pgsql@j-davis.com> wrote:
>
> On Sat, 2025-03-15 at 12:15 -0400, Tom Lane wrote:
>> On the other hand, if we keep up with the Joneses by updating the
>> Unicode data, we can hopefully put those behavioral changes into
>> effect *before* they'd affect any real data.
>
> That's a good point.
Jeff - thanks for the reminder that this is just about character semantics and not ordering. Obviously C collation by
definition(code point ordering) doesn’t change sort order… two weeks ago I was working on updating the torture test
GitHubpage with glibc collation changes up through Ubuntu 24.10 so my mind was definitely over there. No detected
changesin en-US so that’s great news. 🙂
Is the simple answer that functions & clauses related to both time zones and character semantics should just all be
consideredSTABLE instead of IMMUTABLE?
I think if that were the case then changes across a minor version would simply be allowed by definition right? No need
forwarnings.
This would impact the ability to create case-insensitive indexes.
-Jeremy
Sent from my TI-83
