Full text search ts_heading strange result

From: Johann Spies <jspies(at)sun(dot)ac(dot)za>
To: pgsql-general(at)postgresql(dot)org
Subject: Full text search ts_heading strange result
Date: 2012-07-25 08:26:15
Message-ID: 20120725082615.GB17719@sun.ac.za
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

I am beginning to use the full text search facilities in Postgresql
(9.0) and find the result of this query a bit strange:

query:

SELECT ts_headline('simple',title, to_tsquery('kerkreg|(church & polity)'))
from akb_articles A
where A.tsv@@ 'kerkreg|(church & polity)'

Result

"Kerkvereniging en <b>Kerkreg</b>: Geskiedenis, beginsel en praktyk.(<b>Church</b> unity and <b>church</b> polity: History, principle and practice.)"

Why is 'polity' not highlighted?

Regards
Johann

--
Johann Spies Telefoon: 021-808 4699
Databestuurder / Data manager

Sentrum vir Navorsing oor Evaluasie, Wetenskap en Tegnologie
Centre for Research on Evaluation, Science and Technology
Universiteit Stellenbosch.

"Look not every man on his own things, but every man
also on the things of others." Philippians 2:4
E-pos vrywaringsklousule

Hierdie e-pos mag vertroulike inligting bevat en mag regtens geprivilegeerd wees en is slegs bedoel vir die persoon aan wie dit geadresseer is. Indien u nie die bedoelde ontvanger is nie, word u hiermee in kennis gestel dat u hierdie dokument geensins mag gebruik, versprei of kopieer nie. Stel ook asseblief die sender onmiddellik per telefoon in kennis en vee die e-pos uit. Die Universiteit aanvaar nie aanspreeklikheid vir enige skade, verlies of uitgawe wat voortspruit uit hierdie e-pos en/of die oopmaak van enige ls aangeheg by hierdie e-pos nie.

E-mail disclaimer

This e-mail may contain confidential information and may be legally privileged and is intended only for the person to whom it is addressed. If you are not the intended recipient, you are notified that you may not use, distribute or copy this document in any manner whatsoever. Kindly also notify the sender immediately by telephone, and delete the e-mail. The University does not accept liability for any damage, loss or expense arising from this e-mail and/or accessing any files attached to this e-mail.

Responses

Browse pgsql-general by date

  From Date Subject
Next Message leo xu 2012-07-25 11:38:36 how to calculate or know seq_scan scan how many blocks every time
Previous Message Marcin Mańk 2012-07-25 07:47:49 Re: Odd corruption issue reported on dba.stackexchange.com, need advice