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