Ranking search results using multiple fields in PostgreSQL fulltext search

Поиск
Список
Период
Сортировка
От Gaini Rajeshwar
Тема Ranking search results using multiple fields in PostgreSQL fulltext search
Дата
Msg-id 56b36eb60910120616h252434e3q346b40dc2b3c08ff@mail.gmail.com
обсуждение исходный текст
Ответы Re: Ranking search results using multiple fields in PostgreSQL fulltext search  (Raymond O'Donnell <rod@iol.ie>)
Re: Ranking search results using multiple fields in PostgreSQL fulltext search  (Ivan Sergio Borgonovo <mail@webthatworks.it>)
Список pgsql-general
Hi,
is there a way to rank the search results based on multiple fields in postgreSQL?
For example,
i have title, abstract, summary, body as fields/columns in my database. When user searches on title, i want to rank the results based on title field as well as summary field, where importance(summary) > importance(title). But the results should be exactly matching the terms in "title" rather than "title" OR "summary"


В списке pgsql-general по дате отправления:

Предыдущее
От: Peter Eisentraut
Дата:
Сообщение: Re: auth problem
Следующее
От: Raymond O'Donnell
Дата:
Сообщение: Re: Ranking search results using multiple fields in PostgreSQL fulltext search