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

--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general

Reply via email to