Christopher Kings-Lynne wrote:
>>I think it's production quality. Actually, we use it in our
>>projects with 7.3.3. You may read docs on tsearch2 home page
>>http://www.sai.msu.su/~megera/postgres/gist/tsearch/V2/
>
>
> You know what would be an AWESOME feature? The ability to process user
> queries directly:
>
> eg.
>
> SELECT intindex, strtopic FROM tblmessages
> WHERE idxfti @@ 'jam and
> toast -guitar'::userquery::tsquery;
idxfti @@ 'jam & toast & ! guitar'
>
> Or be able to understand stuff like:
>
> 'jam and toast or (jam -guitar)
'(jam & toast) | ( jam & !guitar )'
Sintax of query is boolean expression. Look at 'The tsearch2 Guide'
(http://rhodesmill.org/brandon/projects/tsearch2-guide.html).
--
Teodor Sigaev E-mail: teodor@sigaev.ru