Re: ts_headline - Mailing list pgsql-general

From Richard Huxton
Subject Re: ts_headline
Date
Msg-id 47BD3B21.4090700@archonet.com
Whole thread Raw
In response to ts_headline  (Stephen Davies <scldad@sdc.com.au>)
Responses Re: ts_headline
List pgsql-general
Stephen Davies wrote:
> I am a bit puzzled by the output of ts_headline (V8.3) for different queries.

> It seems that the difference is in the number of occurrences of the criterion
> words. If the number of hits is less than some number, the ts_headline result
> is "correct" but if the number of hits exceeds that limit, the result is just
> the first MinWords of the "document".
>
> I have seen cases with up to 20 hits succeed but cases with 35 hits miss.
> The spread of hits does not seem to be relevant.

http://www.postgresql.org/docs/8.3/static/textsearch-controls.html#TEXTSEARCH-HEADLINE

Are you bumping into the MaxWords limit? If you've got 35 hits that must
be at least 35 words.

--
   Richard Huxton
   Archonet Ltd

pgsql-general by date:

Previous
From: Pascal Cohen
Date:
Subject: Feedback on PLJava
Next
From: hewei
Date:
Subject: Re: How to make update rapidly?