Skip to content

Is there a way to weight the rum_ts_score function? #105

New issue

Have a question about this project? # for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “#”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? # to your account

Open
jalustig opened this issue Apr 8, 2022 · 1 comment
Open

Is there a way to weight the rum_ts_score function? #105

jalustig opened this issue Apr 8, 2022 · 1 comment

Comments

@jalustig
Copy link

jalustig commented Apr 8, 2022

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?

@sokolcati
Copy link
Contributor

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')

# for free to join this conversation on GitHub. Already have an account? # to comment
Labels
None yet
Projects
None yet
Development

No branches or pull requests

2 participants