I'm trying to find a string on a database using FTS on Postgres:
select name
from users
where to_tsvector('simple', name) @@ to_tsquery('simple', 'ad:*')
But the :*
search only the words start with ad.
I found this question Get partial match from Get partial match from GIN indexed TSVECTOR
column column.
But it doesn't mention how to solve the problem of middle and suffix matching using FTS?