In FTS, how do I search for partial substrings that don't form a English word.
Example, in the text: 'one hundred thirty four' I want to find the records based on 'hun'
SELECT to_tsvector('one hundred thirty four') @@ to_tsquery('hun');
does not return anything.
Thanks.