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:*')
:* 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?