Full Text Search

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:

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
---------------------------------------------------------------
*Mai*n title | A table is *compo*sed 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@sai.msu.su, http://www.sai.msu.su/~megera/&lt;http://www.sai.msu.su/%7Emegera/&gt;
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