Re: fts, compond words?

From: Marcus Engene <mengpg(at)engene(dot)se>
To: POSTGRESQL <pgsql-general(at)postgresql(dot)org>
Subject: Re: fts, compond words?
Date: 2005-12-05 20:38:55
Message-ID: 4394A55F.7060504@engene.se
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Oleg Bartunov wrote:
> On Mon, 5 Dec 2005, Marcus Engene wrote:
>
>> Hi,
>>
>> I use the tsearch full text search with pg 8.0.3. It works great, but
>> I wonder if it's possible to search for compound words?
>> Ie if I search for "New York" i want to get a match on
>> New York has traffic problems.
>> but not on
>> New axe murderer incident in brittish York.
>>
>> Is this possible?
>>
>> I don't use any wrapper, just
>> select
>> ...
>> from
>> ...
>> where
>> idxfti @@ to_tsquery('default', 'searchstring')
>
>
>
> ranking function is what you need. Read documentation.
>

Hi,

I realized from the documentation that I'm not looking for
compound words after all, I meant "exact phrase".

I can't see how to make rank tell me which results has an
exact phrase? Like "there must be a occurence of 'new' before
'york'" (stemmed not really exact phrase)?

Is there something new in rank for pg 8.1?

Thanks!
Marcus

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Tom Lane 2005-12-05 20:47:23 Re: 8.1 removed functions
Previous Message vishal saberwal 2005-12-05 20:16:19 Re: Selecting Large Object and TOAST