like operation in tsearch
От
AI Rumman
Тема
like operation in tsearch
Дата
Msg-id
2a7905441003202225v2eb378fdpa2a516eb8f5c5ad9@mail.gmail.com
Список
Дерево обсуждения
like operation in tsearch AI Rumman <rummandba@gmail.com>
Re: like operation in tsearch Oleg Bartunov <oleg@sai.msu.su>
Re: like operation in tsearch AI Rumman <rummandba@gmail.com>
Re: like operation in tsearch Pavel Stehule <pavel.stehule@gmail.com>
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)
c
---
f
(1 row)
I am confused how to execute the above like operation in tsearch.
Any help please.
В списке pgsql-general по дате отправления