Re: case and accent insensitive - Mailing list pgsql-general

From Andreas Kretschmer
Subject Re: case and accent insensitive
Date
Msg-id 89c707df-8d80-81ac-2a0b-e704e97bda26@a-kretschmer.de
Whole thread Raw
In response to case and accent insensitive  (MOISES ESPINOSA <moikmeg@gmail.com>)
List pgsql-general

Am 23.03.2018 um 23:04 schrieb MOISES ESPINOSA:
> I don't know how i could reproduced case insensitive and accent 
> insensitive.

Maybe you can use lower() for case insensitive or citext for the same 
(https://www.postgresql.org/docs/10/static/citext.html) and the 
unaccent-extension
for the accent insensitive 
(https://www.postgresql.org/docs/10/static/unaccent.html)

*untested*


Regards, Andreas

-- 
2ndQuadrant - The PostgreSQL Support Company.
www.2ndQuadrant.com



pgsql-general by date:

Previous
From: rob stone
Date:
Subject: Re: Foreign Key locking / deadlock issue.... v2
Next
From: HORDER Phil
Date:
Subject: RE: Foreign Key locking / deadlock issue.... v2