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
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') @@
2010/3/21 AI Rumman rumman...@gmail.com:
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 o...@sai.msu.su 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