support for ts_headline

[ghost]

It would be awesome to have ts_headline support in sqlalchemy-searchable, see https://www.postgresql.org/docs/current/textsearch-controls.html#TEXTSEARCH-HEADLINE

[jfilter]

I created the query for ts_headline manually:

https://github.com/dmedak/verfassungsschutzberichte.de/blob/ed9cb0baf051159b93a6c7d53f17644051e0dac8/src/app.py#L440

[sebastianelsner]

Thanks, I got this to work, but in the end had to go away from Postgres FTS since it can't do suffix searches for german compound words a la "*:wald" without significant work to be put into custom dictionaries and even then its not "feature complete" since the dictionary might miss words.

[jfilter]

If you want to do suffix search: insert the text reversed and then do a prefix search.

[sebastianelsner]

Yes, but as far as I understand this does not work with "Donaudampfschiffahrtsgesellschaftskapitän" :D

[jfilter]

I see. ;)