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
Есть вопросы? Напишите нам!
Соглашаюсь с условиями обработки персональных данных
✖
By continuing to browse this website, you agree to the use of cookies. Go to Privacy Policy.