Hello, A french user recently complained that with an index created using gin_trgm_ops (or gist_trgm_ops), you can use the index with a clause like
col LIKE 'something' but not col = 'something' even though both clauses are technically identical. That's clearly not a high priority thing to support, but looking at the code it seems to me that this could be achieved quite simply: just adding a new operator = in the opclass, with an operator strategy number that falls back doing exactly what LikeStrategyNumber is doing and that's it. There shouldn't be any wrong results, even using wildcards as the recheck will remove any incorrect one. Did I miss something? And if not would such a patch be welcome?