subject:"\[ADMIN\] Partial substrings in FTS"

Re: [ADMIN] Partial substrings in FTS

2012-04-23 Thread Jesper Krogh

On 23/04/2012, at 19.10, A J 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

Re: [ADMIN] Partial substrings in FTS

2012-04-23 Thread Kevin Grittner

A J 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. It sou

[ADMIN] Partial substrings in FTS

2012-04-23 Thread A J

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.