Ranking search results using multiple fields in PostgreSQL fulltext search - Mailing list pgsql-general

From Gaini Rajeshwar
Subject Ranking search results using multiple fields in PostgreSQL fulltext search
Date
Msg-id 56b36eb60910120616h252434e3q346b40dc2b3c08ff@mail.gmail.com
Whole thread Raw
Responses Re: Ranking search results using multiple fields in PostgreSQL fulltext search
Re: Ranking search results using multiple fields in PostgreSQL fulltext search
List 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 by date:

Previous
From: Peter Eisentraut
Date:
Subject: Re: auth problem
Next
From: Raymond O'Donnell
Date:
Subject: Re: Ranking search results using multiple fields in PostgreSQL fulltext search