How do you index for a LIKE '%pattern%' search without going full-text?
Leading-wildcard LIKE can't use a btree. trigram indexes help, but full-text search changes semantics. For a simple contains-filter, what's the pragmatic choice?
30
0 commentsLeading-wildcard LIKE can't use a btree. trigram indexes help, but full-text search changes semantics. For a simple contains-filter, what's the pragmatic choice?