Re: Full Text Search

["andy petrella" <andy.petrella@xxxxxxxxx>]

On Fri, Apr 25, 2008 at 6:56 PM, Oleg Bartunov <oleg@xxxxxxxxxx> wrote:

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.

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

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@xxxxxxxxxx, 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@xxxxxxxxx
 - ap@xxxxxxxxxxxxx
********
phone : 
 +32495991104