Postgres Pro
Downloads
Home   >   mailing lists

[feature request] ts_headline should have an option to highlight only full matches of <-> expressions - Mailing list pgsql-hackers

From Jake North
Subject [feature request] ts_headline should have an option to highlight only full matches of <-> expressions
Date
Msg-id MsulbjG--3-2@tuta.io
Whole thread Raw
Responses Re: [feature request] ts_headline should have an option to highlight only full matches of <-> expressions
List pgsql-hackers
Tree view 
Hi,

I am using Postgres' full text search since some time now and overall it's working really well for me. However one
issueI have is that ts_headline highlights partial matches of FOLLOWED BY (<->) expressions, e.g. 

SELECT ts_headline('some words and some more words', to_tsquery('some<->words'));

gives

<b>some</b> <b>words</b> and <b>some</b> more <b>words</b>

while I expect

<b>some words</b> and some more words

I think the highlights of partial matches is in most cases not useful and confusing to end users, they may think the
searchdid not recognize they requested the words to be consecutive. Google also does not highlight partial matches it
seems.

I suspect to implement this would require substantial changes to ts_headline since it seems to treat the lexemes
independently,but it would be a big improvement and should be the default behaviour. 

Best regards,
Jake N

pgsql-hackers by date:

Previous
From: Tom Lane
Date:
Subject: Re: Index-only scan for btree_gist turns bpchar to char
Next
From: Aliaksandr Kalenik
Date:
Subject: Re: [PATCH] reduce page overlap of GiST indexes built using sorted method