like operation in tsearch - Mailing list pgsql-general

I am using Postgresql 8.1 tsearch2.

 

I need to match a like operation in tsearch. Such as,

 

Sample data:

 

Document

......................

 

Rumman went to iftekhar to solve it.

 

 

select ...

from ...

where document like '%ifte%'

 

need to be written in tsearch. Here "ifte" is a name

 

But in tsearch when I am using to_tsvector, it gives as follows-

 

 'iftekhar':4 'rumman':1 'solv':6 'went':2

 

postgres=# select to_tsvector('Rumman went to iftekhar to solve it') @@ to_tsquery('ifte') as c;
 c
---
 f
(1 row)

 

I am confused how to execute the above like operation in tsearch.

 

Any help please.