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
Last activity: Feb 28, 2020, 12:18 PM