| From: | Peter Eisentraut <peter(dot)eisentraut(at)2ndquadrant(dot)com> |
|---|---|
| To: | Daniel Heath <daniel(at)heath(dot)cc>, pgsql-hackers(at)postgresql(dot)org |
| Subject: | Re: Custom text type for title text |
| Date: | 2019-01-03 23:58:21 |
| Message-ID: | 79303b77-0572-ac1f-e4b1-7096b17036f5@2ndquadrant.com |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-hackers |
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
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Tomas Vondra | 2019-01-04 00:01:01 | Re: Delay locking partitions during query execution |
| Previous Message | Fabrízio de Royes Mello | 2019-01-03 23:52:57 | Re: Custom text type for title text |