Would this also be appropriate for inclusion as contrib? I'm unfamiliar with the policy for what is / is not included there. Thanks, Daniel Heath
On Fri, Jan 4, 2019, at 9:47 AM, Fabrízio de Royes Mello wrote: > > > Em qui, 3 de jan de 2019 às 20:22, Daniel Heath <dan...@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[1] >> 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 Links: 1. https://www.postgresql.org/message-id/CAKFQuwY9u14TqG8Yzj=fab0tydvvtk7ibgfex3tegbpwsgj...@mail.gmail.com