Re: ts_headline - Mailing list pgsql-general

From Stephen Davies
Subject Re: ts_headline
Date
Msg-id 200802211959.40300.scldad@sdc.com.au
Whole thread Raw
In response to Re: ts_headline  (Richard Huxton <dev@archonet.com>)
Responses Re: ts_headline
List pgsql-general
G'day Richard.

I don't think so. A sample command is:

ts_headline(abstract,to_tsquery('english','database'),'minWords = 99, maxWords
= 999')

I have also tried with smaller maxwords without any visible effect.

Cheers,
Stephen


On Thursday 21 February 2008 19:19, Richard Huxton wrote:
> 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#TEXTSEAR
>CH-HEADLINE
>
> Are you bumping into the MaxWords limit? If you've got 35 hits that must
> be at least 35 words.

--
========================================================================
This email is for the person(s) identified above, and is confidential to
the sender and the person(s).  No one else is authorised to use or
disseminate this email or its contents.

Stephen Davies Consulting                            Voice: 08-8177 1595
Adelaide, South Australia.                             Fax: 08-8177 0133
Computing & Network solutions.                       Mobile:0403 0405 83

pgsql-general by date:

Previous
From: hewei
Date:
Subject: Re: How to make update rapidly?
Next
From: Richard Huxton
Date:
Subject: Re: ts_headline