Casecommons/pg_search

Option to disable ranking

rhymes opened this issue · 2 comments

There are cases when computing ranking between search results and the default order by ORDER BY rank DESC, id ASC is not required.

Although the default ordering can be disabled with .reorder(nil) the ranking computation itself can't be disabled.

I wish there was a an option for pg_search's ranked_by to disable it.

Something like: rank: false or ranked_by: false

If I'm not mistaken it should be possible by making this optional:

def rank
(config.ranking_sql || ":tsearch").gsub(/:(\w*)/) do
feature_for(Regexp.last_match(1)).rank.to_sql
end
end

so that if config.ranking_sql (which is the value of options[:ranked_by]) is explicitly set to false ranking can be skipped entirely.

I can try to transform this idea into a PR, let me know

fauno commented

fwiw i could apply my own ordering by monkey-patching PgSearch::ScopeOptions#apply from line 21:

https://github.com/Casecommons/pg_search/blob/master/lib/pg_search/scope_options.rb#L21-L23

module PgSearch
  ScopeOptions.class_eval do
    def apply(scope)
      scope = include_table_aliasing_for_rank(scope)
      rank_table_alias = scope.pg_search_rank_table_alias(include_counter: true)

      scope.joins(rank_join(rank_table_alias))
    end
  end
end