Обсуждение: like operation in tsearch
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.
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
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 <oleg@sai.msu.su> wrote:
We introduced prefix support in 8.4, so one may use:t
=# select to_tsvector('Rumman went to iftekhar to solve it') @@ to_tsquery('ifte:*') as c;
c ---
(1 row)Regards,
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.
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
2010/3/21 AI Rumman <rummandba@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 <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 > >