From: | Telford Tendys <psql(at)lnx-bsp(dot)net> |
---|---|
To: | Thomas Munro <thomas(dot)munro(at)gmail(dot)com> |
Cc: | PostgreSQL mailing lists <pgsql-bugs(at)lists(dot)postgresql(dot)org> |
Subject: | Re: Unicode FFFF Special Codepoint should always collate high. |
Date: | 2021-06-23 10:21:38 |
Message-ID: | 20210623102138.GA18446@mail |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-bugs |
On 21-06-23 18:18, Thomas Munro wrote:
> Just in case you didn't know, PostgreSQL knows how to convert a prefix
> search for 'aar%' into a range search with a related trick in some
> limited circumstances:
Thanks for the suggestion, I probably should learn those tricks but
for the time being, would prefer to live with a slower search and get it
eventually done the way I want.
> Seems a little light on references and justifications for the
> expectiation. ICU's results could be useful in the discussion.
I trust those guys, they will figure it out. I strongly predict that
they will keep the behaviour consistent with RHEL 7.
Is there an easy way to make normal Linux glibc utilities (e.g. sort)
use a locale from the ICU library? There's a package availble one Centos-8
here:
libicu-60.3-2.el8_1.x86_64
Trouble is that only a few applications use it, and I can't find any way
to plug-in / plug-out this functionality. Introducing postgresql details to
the bugzilla ticket will muddy the water and create a aura of diffuse
responsibility. What I've found is generally where there's a lot of words,
people don't read them.
From | Date | Subject | |
---|---|---|---|
Next Message | Guillaume Lelarge | 2021-06-23 11:54:15 | Re: Example in "42.8. Transaction Management" doesn't work for PostgreSQL v 12.7 |
Previous Message | Thomas Munro | 2021-06-23 09:45:10 | Re: BUG #17064: Parallel VACUUM operations cause the error "global/pg_filenode.map contains incorrect checksum" |