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 ?
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) ?
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