> On Mar 15, 2025, at 10:22 AM, Jeff Davis <pg...@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 GitHub page with glibc collation changes up through Ubuntu 24.10 so my mind was definitely over there. No detected changes in 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 considered STABLE 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 for warnings. This would impact the ability to create case-insensitive indexes. -Jeremy Sent from my TI-83