Search results should prioritize first post in topic when title matches search term

[tgxworld (Alan Tan)]

@Sailsman63

This is non-obvious,

The idea is that we will make UX changes to make this obvious.

@Sailsman63

Perhaps consider a two-stage search?

• Search Topic Titles, matching only on EXACT_MATCH and CONTAINS_ALL
  • These get placed at the top of the results, with EXACT_MATCH getting priority
• Then, fill in the rest of the results using the current weighted search, excluding any topic-starter posts that were caught by the first stage.

The idea is sound but I don’t think we can execute the postgres search query efficiently since there is no index support when trying to match with the like and ilike operators. Another factor to consider is that there is no way to rank exact match or contains matches. This is the reason why we rely full text search capabilities that Postgres provides.