Re: tsearch2 for 7.3.X

From: "Christopher Kings-Lynne" <chriskl(at)familyhealth(dot)com(dot)au>
To: "Teodor Sigaev" <teodor(at)sigaev(dot)ru>
Cc: "Oleg Bartunov" <oleg(at)sai(dot)msu(dot)su>, "Andreas Joseph Krogh" <andreak(at)officenet(dot)no>, "Bruce Momjian" <pgman(at)candle(dot)pha(dot)pa(dot)us>, "Pgsql Hackers" <pgsql-hackers(at)postgresql(dot)org>
Subject: Re: tsearch2 for 7.3.X
Date: 2003-07-23 01:17:28
Message-ID: 0d9d01c350b8$8f1ec9b0$2800a8c0@mars
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

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

In response to

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Christopher Kings-Lynne 2003-07-23 01:18:53 Re: php with postgres
Previous Message Jenny - 2003-07-23 01:00:58 table-level and row-level locks.