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 ---------------------------(end of broadcast)--------------------------- TIP 9: In versions below 8.0, the planner will ignore your desire to choose an index scan if your joining column's datatypes do not match
