Re: tsearch2 for 7.3.X - Mailing list pgsql-hackers

From Teodor Sigaev
Subject Re: tsearch2 for 7.3.X
Date
Msg-id 3F1D062D.80404@sigaev.ru
Whole thread Raw
In response to Re: tsearch2 for 7.3.X  ("Christopher Kings-Lynne" <chriskl@familyhealth.com.au>)
List pgsql-hackers

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



pgsql-hackers by date:

Previous
From: Lee Kindness
Date:
Subject: PATCH: Memory leaks on start-up
Next
From: Lee Kindness
Date:
Subject: threads.c