SQLite Forum

FTS5: calculating column weight dynamically?
> The built-in bm25() function is just an example of an FTS5 custom function, which is really just an SQLite scalar user function that has access to this API:

Thank you, Dan. i had forgotten that it's possible to customize that via custom functions - my thought train was along the lines of long/convoluted CASE blocks. This is yet another rabbit hole for me to crawl into :-D.