Postgres Pro
Downloads
Home   >   mailing lists

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

From Christopher Kings-Lynne
Subject Re: tsearch2 for 7.3.X
Date
Msg-id 0d9d01c350b8$8f1ec9b0$2800a8c0@mars
Whole thread Raw
In response to Re: tsearch2 for 7.3.X  (Bruce Momjian <pgman@candle.pha.pa.us>)
Responses Re: tsearch2 for 7.3.X  (Oleg Bartunov <oleg@sai.msu.su>)
List pgsql-hackers
Tree view 
> > SELECT intindex, strtopic FROM tblmessages
> >                                   WHERE idxfti @@ 'jam and
> > toast -guitar'::userquery::tsquery;
>
> idxfti @@ 'jam & toast & ! guitar'

I mean, the end user - the person entering the search string on the website
won't know that syntax...

Chris

pgsql-hackers by date:

Previous
From: "Christopher Kings-Lynne"
Date:
Subject: Re: php with postgres
Next
From: "Christopher Kings-Lynne"
Date:
Subject: Re: suggestions to improve postgresql suitability for data-mining