pg.ddx.io  pgsql-hackers@postgresql.org mailing list archive  

help / color / mirror / Atom feed
From: Finnerty, Jim <jfinnert@amazon.com>
To: Peter Eisentraut <peter.eisentraut@enterprisedb.com>
To: Julien Rouhaud <rjuju123@gmail.com>
Cc: pgsql-hackers <pgsql-hackers@postgresql.org>
Cc: Daniel Verite <daniel@manitou-mail.org>
Subject: Re: ICU for global collation
Date: Mon, 17 Jan 2022 17:30:45 +0000
Message-ID: <AA17A355-C7EA-4EA2-87C3-F591C2D481FE@amazon.com> (raw)
In-Reply-To: <a6f807c2-2d11-2cf6-a524-cfbec56e7d5b@enterprisedb.com>
References: <374f8048-9d87-462c-a8aa-d02ffca6525f@manitou-mail.org>
	<d7060bf1-177c-e0f2-f13f-b857cdd1182e@2ndquadrant.com>
	<525ef44f-52bf-505f-a491-07835d039424@enterprisedb.com>
	<YdOvEAFGbfGY/47A@jrouhaud>
	<bba413de-5548-3480-e8f8-1ced562a866b@enterprisedb.com>
	<ed3baa81-7fac-7788-cc12-41e3f7917e34@enterprisedb.com>
	<20220110032508.4eyz6m6mpvt622la@jrouhaud>
	<20220110060027.egvaly4lskylo22f@jrouhaud>
	<c3093547-6ce2-66ca-71de-3a3c633cfb02@enterprisedb.com>
	<20220111110852.t5oxfga57llm5cy2@jrouhaud>
	<a6f807c2-2d11-2cf6-a524-cfbec56e7d5b@enterprisedb.com>

Re: 
>> After this patch goes in, the big next thing would be to support
>> nondeterministic collations for LIKE, ILIKE and pattern matching operators in
>> general.  Is anyone interested in working on that?

> As far as I know you're the last person that seemed to be working on that topic
> back in March :)

I have a solution for LIKE and ILIKE for case-insensitive, accent-sensitive ICU collations and the UTF8 server encoding, but didn't attempt to address the general case until ICU collations were supported at the database and cluster levels.  I may have another look at that after this patch goes in.




view thread (111+ messages)  latest in thread

Message-ID: <AA17A355-C7EA-4EA2-87C3-F591C2D481FE@amazon.com>
Permalink:  ../AA17A355-C7EA-4EA2-87C3-F591C2D481FE@amazon.com/
Also on:    postgresql.org/message-id/AA17A355-C7EA-4EA2-87C3-F591C2D481FE@amazon.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-hackers@postgresql.org
  Cc: jfinnert@amazon.com, peter.eisentraut@enterprisedb.com, rjuju123@gmail.com, daniel@manitou-mail.org
  Subject: Re: ICU for global collation
  In-Reply-To: <AA17A355-C7EA-4EA2-87C3-F591C2D481FE@amazon.com>

* Save the following mbox file, import it into your mail client,
  and reply-to-all from there: mbox

This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox