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 <o...@sai.msu.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: o...@sai.msu.su, http://www.sai.msu.su/~megera/ > phone: +007(495)939-16-83, +007(495)939-23-83 >