| From: | Richard Huxton <dev(at)archonet(dot)com> |
|---|---|
| To: | Stephen Davies <scldad(at)sdc(dot)com(dot)au> |
| Cc: | pgsql-general(at)postgresql(dot)org |
| Subject: | Re: ts_headline |
| Date: | 2008-02-21 10:20:02 |
| Message-ID: | 47BD5052.1090509@archonet.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general pgsql-patches |
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
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Howard Wilkinson | 2008-02-21 10:44:32 | Querying the schema for column widths - what syntax do I use? |
| Previous Message | Alexey Nalbat | 2008-02-21 10:08:00 | unnesesary sorting after Merge Full Join |
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Stephen Davies | 2008-02-21 11:10:30 | Re: ts_headline |
| Previous Message | Stephen Davies | 2008-02-21 09:46:31 | Re: ts_headline |