PostgreSQL version: 10.15
Operating system: Linux/Ubuntu
Bug when using ts_headline with the <-> operator
Assuming the following query:
SELECT ts_headline('simple','The Cyberpunk launch did not go as expected for Cyberpunk Fans around the world', phraseto_tsquery('simple','Cyberpunk Fans')::tsquery);
The returned result is:
The <b>Cyberpunk</b> launch did not go as expected for <b>Cyberpunk</b> <b>Fans</b> around the world
This highlights the Cyberpunk alone in addition to Cyberpunk Fans.
However, the expected output would be:
The Cyberpunk launch did not go as expected for <b>Cyberpunk</b> <b>Fans</b> around the world
Which only highlights *Cyberpunk Fans* due to the <-> operator in phraseto_tsquery.
SELECT phraseto_tsquery('simple','Cyberpunk Fans');
The above returns 'cyberpunk<-> 'fans' as expected, so presumably this is an issue with the ts_headline function.
I would be great to see this fixed/improved in the near future.
Christian