Re: case and accent insensitive search under Python ?

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.

case and accent insensitive search under Python ?

Hi, I'm considering to migrate to postgresql... ( still examining the pro/con ) 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

Re: case and accent insensitive

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

case and accent insensitive

Hi, I need to reproduced the following Oracle functionality in PostgreSQL: CREATE INDEX index_ciudad ON world.ciudad ((NLSSORT(NOMBRE29,'nls_sort=''GENERIC_BASELETTER'''))); I don't know how i could reproduced case insensitive and accent insensitive. Is there any collate? Thanks.