Re: ts_headline

Stephen Davies wrote:
> Attached is the "document" in question.
>
> Searches for "norwegian", "thesaurus" and "statement" give good results. A
> search for "database" gives the plain text from the beginning.

Seems OK here - might need to look at your configuration settings.
http://www.postgresql.org/docs/8.3/static/textsearch-debugging.html

I'll make sure I've got a clean setup here and re-run the test.


SELECT ts_headline(t, to_tsquery('database')) FROM tsearch_test;
                                               ts_headline
-------------------------------------------------------------------------------------------------------
  <b>database</b> (using a 2 KB page) to a Large File Support (LFS)
<b>database</b> (using an 8 KB page
(1 row)

--
   Richard Huxton
   Archonet Ltd