Customize search clause for fulltext search
Currently search clause for fulltext is using "@@" operator for PostgreSQL with tsvector/tsquery. But I would like to use "LIKE" operator with re-generated index for better search using language specific algorithm(e.g. Japanese).
Now search clause template is "@@ %s". I would like to replace it to "LIKE %s" or "LIKE func(%s)".
![](https://secure.gravatar.com/avatar/eeeb5e36867ce049041d4d8801a5775a?size=40&default=https%3A%2F%2Fassets.uvcdn.com%2Fpkg%2Fadmin%2Ficons%2Fuser_70-6bcf9e08938533adb9bac95c3e487cb2a6d4a32f890ca6fdc82e3072e0ea0368.png)
-
Tom Cross commented
This is massively important. If you have a lot of channels and you're trying to follow a naming convention for channels, if you want to find the marketing channel, you're going to type "Marketing" and get no hits because you don't know to add "Global:Product:" first or something like that.
-
柏木りんね commented
Sorry, my name includes "kanji" in Japanese. My nick name is "rin_ne".