Re: case and accent insensitive search under Python ?

2023-08-19 Thread Tom Lane
M4X <77...@gmx.com> writes: > It seem that is possible to make a search that is case and accent > insensitive. > |I've dig https://www.postgresql.org/docs/current/textsearch-intro.html > and other resources,| > |but I didn't find yet an example that demonstrate it. The text search functionality is

Re: case and accent insensitive

2018-03-24 Thread Andreas Kretschmer
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 accen