Re: Custom text type for title text

Поиск
Список
Период
Сортировка
От Fabrízio de Royes Mello
Тема Re: Custom text type for title text
Дата
Msg-id CAFcNs+q9FZhe=GBm3Rp4SJa335_j4XpUV3GwL-1s46NZ1bG08w@mail.gmail.com
обсуждение исходный текст
Ответ на Custom text type for title text  (Daniel Heath <daniel@heath.cc>)
Ответы Re: Custom text type for title text  (Daniel Heath <daniel@heath.cc>)
Список pgsql-hackers


Em qui, 3 de jan de 2019 às 20:22, Daniel Heath <daniel@heath.cc> escreveu:
Hi All,

I've frequently seen an issue in applications which store titles (eg of books, events, user profiles) where duplicate values are not properly vetted. 

The 'citext' type is helpful here, but I'd be keen to go further. 

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)

This would be useful for a range of situations where it's important to avoid entering duplicate values.

Given the discussion at https://www.postgresql.org/message-id/CAKFQuwY9u14TqG8Yzj%3DfAB0tydvvtK7ibgFEx3tegbPWsGjJpg%40mail.gmail.com I'd lean towards making this type not automatically coerce to text (to avoid surprising behaviour when comparing text to titletext).

Is a suitable patch likely to be accepted?

You don’t need touch the core to do that. Just implement it as an extension and share throught some channel like pgxn.org.

Note that citext also is an extension and released as a contrib module.

Regards,

--
   Fabrízio de Royes Mello         Timbira - http://www.timbira.com.br/
   PostgreSQL: Consultoria, Desenvolvimento, Suporte 24x7 e Treinamento

В списке pgsql-hackers по дате отправления:

Предыдущее
От: Daniel Heath
Дата:
Сообщение: Custom text type for title text
Следующее
От: Tomas Vondra
Дата:
Сообщение: Re: Delay locking partitions during query execution