Re: phrase search - Mailing list pgsql-hackers

From Teodor Sigaev
Subject Re: phrase search
Date
Msg-id 48458A8E.6080306@sigaev.ru
Whole thread Raw
In response to Re: phrase search  (Sushant Sinha <sushant354@gmail.com>)
Responses Re: phrase search  (Sushant Sinha <sushant354@gmail.com>)
List pgsql-hackers
> This is far more complicated than I thought.
>> Of course, phrase search should be able to use indexes.
> I can probably look into how to use index. Any pointers on this?

src/backend/utils/adt/tsginidx.c, if you invent operation #  in tsquery then you 
will have index support with minimal effort.
> 
> Yes this is exactly how I am using in my application. Do you think this
> will solve a lot of common case or we should try to get phrase search

Yeah, it solves a lot of useful case, for simple use it's needed to invent 
function similar to existsing plaitnto_tsquery, say phraseto_tsquery. It should 
produce correct tsquery with described above operations.

-- 
Teodor Sigaev                                   E-mail: teodor@sigaev.ru
  WWW: http://www.sigaev.ru/
 


pgsql-hackers by date:

Previous
From: James William Pye
Date:
Subject: Re: rfc: add pg_dump options to dump output
Next
From: Teodor Sigaev
Date:
Subject: Re: [GENERAL] Fragments in tsearch2 headline