Would this also be appropriate for inclusion as contrib? I'm unfamiliar with the policy for what is / is not included there.
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 <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.
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,
--
PostgreSQL: Consultoria, Desenvolvimento, Suporte 24x7 e Treinamento