From: | Stephen Davies <scldad(at)sdc(dot)com(dot)au> |
---|---|
To: | Richard Huxton <dev(at)archonet(dot)com> |
Cc: | pgsql-general(at)postgresql(dot)org |
Subject: | Re: ts_headline |
Date: | 2008-02-21 09:29:40 |
Message-ID: | 200802211959.40300.scldad@sdc.com.au |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general pgsql-patches |
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
From | Date | Subject | |
---|---|---|---|
Next Message | Richard Huxton | 2008-02-21 09:38:05 | Re: ts_headline |
Previous Message | Gordon | 2008-02-21 09:15:52 | Re: How to make update rapidly? |
From | Date | Subject | |
---|---|---|---|
Next Message | Richard Huxton | 2008-02-21 09:38:05 | Re: ts_headline |
Previous Message | Richard Huxton | 2008-02-21 08:49:37 | Re: ts_headline |