Re: Partial substrings in FTS

[Jesper Krogh <jesper@xxxxxxxx>]

On 23/04/2012, at 19.10, A J <s5aly@xxxxxxxxx> wrote:

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.

Try to_tsquery('hun:*') 

Jesper