Thread: Full Text Search
Hi All,
I've some question about the new full text search capability. Is it a way to have wildcard (or smth like) in the query ?
Or do we have to add dictionaries ? If yes what kind (for english for example) ?
TY
Best.
andy
I've some question about the new full text search capability. Is it a way to have wildcard (or smth like) in the query ?
Or do we have to add dictionaries ? If yes what kind (for english for example) ?
TY
Best.
andy
On Fri, 25 Apr 2008, andy petrella wrote: > Hi All, > > I've some question about the new full text search capability. Is it a way to > have wildcard (or smth like) in the query ? in 8.4 text search will support prefix search and operation LIKE '%asd%' will have index support. > Or do we have to add dictionaries ? If yes what kind (for english for > example) ? something like dict_regex ? http://vo.astronet.ru/arxiv/dict_regex.html > > TY > > Best. > > andy > 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
On Fri, Apr 25, 2008 at 6:56 PM, Oleg Bartunov <oleg@sai.msu.su> wrote:
Actually, what I want to be able to do is more something like :
It's why I want to know if we need to add an additional dictionary where completion (f.i.) is taken into account (ispell ?)
thanks for answering.
andy
On Fri, 25 Apr 2008, andy petrella wrote:in 8.4 text search will support prefix search and operationHi All,
I've some question about the new full text search capability. Is it a way to
have wildcard (or smth like) in the query ?
LIKE '%asd%' will have index support.
Actually, what I want to be able to do is more something like :
SELECT title, body
FROM pgweb
WHERE to_tsvector(title || body) @@ to_tsquery('Mai% & compo%')
title | body
---------------------------------------------------------------
Main title | A table is composed by cells
It's why I want to know if we need to add an additional dictionary where completion (f.i.) is taken into account (ispell ?)
thanks for answering.
andy
something like dict_regex ?Or do we have to add dictionaries ? If yes what kind (for english for
example) ?
http://vo.astronet.ru/arxiv/dict_regex.html
TY
Best.
andy
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
--
Andy Petrella
Belgium (Liège)
********
- Graduate in Mathematics
- Graduate in Informatics
- Software Engineer at Leica Belgium (http://www.ionicsoft.com - http://gi.leica-geosystems.com)
********
mail :
- andy.petrella@gmail.com
- ap@ionicsoft.com
********
phone :
+32495991104