Horton

Re: insensitive collations

Peter Eisentraut <peter.eisentraut@2ndquadrant.com>

View thread View on postgr.es
From: Peter Eisentraut <peter.eisentraut@2ndquadrant.com>
To: Daniel Verite <daniel@manitou-mail.org>
Cc: Peter Geoghegan <pg@bowt.ie>, pgsql-hackers <pgsql-hackers@postgresql.org>
Date: 2019-03-08T10:07:55Z
Lists: pgsql-hackers

Attachments

On 2019-03-04 15:58, Daniel Verite wrote:
> For the LIKE operator, I think the fix should be that like_fixed_prefix() 
> should always return Pattern_Prefix_None for non-deterministic collations.

Good catch.  I added the fix to match_pattern_prefix() instead.  That
would be the place to change if someone wanted to fix this properly in
the future.  While testing this, I also found a somewhat related problem
with _pattern_ops operator classes, which also need to be prohibited
with nondeterministic collations.

Updated patch attached, also with some merge conflicts resolved.

-- 
Peter Eisentraut              http://www.2ndQuadrant.com/
PostgreSQL Development, 24x7 Support, Remote DBA, Training & Services

Commits

  1. Collations with nondeterministic comparison

  2. Add support for collation attributes on older ICU versions

  3. Make type "name" collation-aware.

  4. Make collation-aware system catalog columns use "C" collation.

  5. Adjust string comparison so that only bitwise-equal strings are considered