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)".
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.
Sorry, my name includes "kanji" in Japanese. My nick name is "rin_ne".