rum icon indicating copy to clipboard operation
rum copied to clipboard

Is there a way to weight the rum_ts_score function?

Open jalustig opened this issue 3 years ago • 1 comments

I have a tsvector column that combines texts with different weights (e.g. title and body of the document are weighted differently).

Using the built-in sql function ts_rank, you can add a weighting component to the function, e.g. ts_rank('{0.8, 1.0}', my_tsvector, to_tsquery('test'))

Is there a way to do a similar weighting using the RUM function, rum_ts_score?

I checked the source and the function does have weights, but from what I can tell this isn't made available via the function itself. Is there a way to use weighting with the RUM function?

jalustig avatar Apr 08 '22 04:04 jalustig

The rum_ts_score() function is used inside the <=> operator. So, instead of using ts_rank(fts,plainto_tsquery('english', 'some string')) you should use fts <=> plainto_tsquery('english', 'some string')

sokolcati avatar Feb 12 '25 17:02 sokolcati