Re: [GENERAL] like operation in tsearch

2010-03-21 Thread Pavel Stehule
2010/3/21 AI Rumman : > Helo, > > I am using Postgresql 8.1 and I found that to_tsquery('iftek:*) gives systax > error. > you have to upgrade to 8.4 when you would to use this feature regards Pavel Stehule > On Sun, Mar 21, 2010 at 12:11 PM, Oleg Bartunov wrote: >> >> We introduced prefix suppo

Re: [GENERAL] like operation in tsearch

2010-03-21 Thread AI Rumman
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 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

Re: [GENERAL] like operation in tsearch

2010-03-20 Thread Oleg Bartunov
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,