Postgres Pro
Downloads
Home   >   mailing lists

Re: Full Text Search - Mailing list pgsql-general

From andy petrella
Subject Re: Full Text Search
Date
Msg-id 7159e12c0804251007t3dc6239dsdc220a317467220e@mail.gmail.com
Whole thread Raw
In response to Re: Full Text Search  (Oleg Bartunov <oleg@sai.msu.su>)
List pgsql-general
Tree view


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
---------------------------------------------------------------
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@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

pgsql-general by date:

Previous
From: "Rhys Stewart"
Date:
Subject: Re: query question really cant give a summary here so read the body ;-)
Next
From: Colin Wetherbee
Date:
Subject: Re: query question really cant give a summary here so read the body ;-)