Sample Header Ad - 728x90

Creating a case-insensitive and accent/diacritics insensitive search on a field

6 votes
1 answer
12545 views
I would like to know if it makes sense to create an index combining two functions while using Full Text Search: lower(name) and f_unaccent(name) Where f_unaccent is just my wrapper to make unaccent function immutable. I do have an index working on: f_unaccent(name) using varchar_pattern_ops. My question is: would an index that combines lower and unaccent functions be triggered by full_text_search lower(f_unaccent(name)). I don't know if the lower function would be useful working with Full Text Search algorithms.
Asked by Rubén_ic (63 rep)
Jun 22, 2017, 03:45 PM
Last activity: Feb 28, 2020, 12:18 PM