Re: ts_headline

Interesting. I hadn't seen that section before.

As I said in my original post: "Is this a bug or am I missing some
configuration option".

I shall investigate the stuff in 12.8.
Any suggestions as to where to start?

Thanks,
Stephen Davies

On Thursday 21 February 2008 20:50, Richard Huxton wrote:
> 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)

--
========================================================================
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