Re: like operation in tsearch

Helo,

I am using Postgresql 8.1 and I found that to_tsquery('iftek:*) gives systax
error.

On Sun, Mar 21, 2010 at 12:11 PM, Oleg Bartunov <oleg(at)sai(dot)msu(dot)su> wrote:

> We introduced prefix support in 8.4, so one may use:
>
>
> =# select to_tsvector('Rumman went to iftekhar to solve it') @@
> to_tsquery('ifte:*') as c;
> c ---
> t
> (1 row)
>
>
>
> On Sun, 21 Mar 2010, AI Rumman wrote:
>
> 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.
>>
>>
> Regards,
> Oleg
> _____________________________________________________________
> Oleg Bartunov, Research Scientist, Head of AstroNet (www.astronet.ru),
> Sternberg Astronomical Institute, Moscow University, Russia
> Internet: oleg(at)sai(dot)msu(dot)su, http://www.sai.msu.su/~megera/
> phone: +007(495)939-16-83, +007(495)939-23-83
>