On 03/01/2019 23:22, Daniel Heath wrote:
> I propose a 'titletext' type, which has the following properties when
> compared for equality:
> * Case insensitivity (like 'citext')
> * Only considers characters in [:alnum:] (that is, ignores spaces,
> punctuation, etc)
My work on insensitive/non-deterministic collations[0] might cover this.
[0]:
https://www.postgresql.org/message-id/flat/1ccc668f-4cbc-0bef-af67-450b47cdfee7%402ndquadrant.com
For example:
CREATE COLLATION yournamehere (provider = icu,
locale = 'und-u-ks-level2-ka-shifted', deterministic = false);
(Roughly, ks-level2 means ignore case, ka-shifted means ignore punctuation.)
--
Peter Eisentraut http://www.2ndQuadrant.com/
PostgreSQL Development, 24x7 Support, Remote DBA, Training & Services