Re: ts_headline

[Richard Huxton <dev@xxxxxxxxxxxx>]

Stephen Davies wrote:
> 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.

Hmm - a simple test seems to work OK.

SELECT ts_headline( repeat('apple banana carrot ', 100), 
to_tsquery('apple'));
                                                              ts_headline
----------------------------------------------------------------------------------------------------------------------------------------
 <b>apple</b> banana carrot <b>apple</b> banana carrot <b>apple</b> 
banana carrot <b>apple</b> banana carrot <b>apple</b> banana carrot
(1 row)

It's not just the start of the text either:

SELECT ts_headline( repeat('elephant ', 100) || repeat('apple banana 
carrot ', 100), to_tsquery('apple'));
                                                              ts_headline
----------------------------------------------------------------------------------------------------------------------------------------
 <b>apple</b> banana carrot <b>apple</b> banana carrot <b>apple</b> 
banana carrot <b>apple</b> banana carrot <b>apple</b> banana carrot
(1 row)

Can you provide a piece of text that shows the problem?

--
  Richard Huxton
  Archonet Ltd

---------------------------(end of broadcast)---------------------------
TIP 3: Have you checked our extensive FAQ?

              http://www.postgresql.org/docs/faq