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