Ranking search results using multiple fields in PostgreSQL fulltext search

From: Gaini Rajeshwar <raja(dot)rajeshwar2006(at)gmail(dot)com>
To: pgsql-general(at)postgresql(dot)org
Subject: Ranking search results using multiple fields in PostgreSQL fulltext search
Date: 2009-10-12 13:16:02
Message-ID: 56b36eb60910120616h252434e3q346b40dc2b3c08ff@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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"

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Raymond O'Donnell 2009-10-12 13:23:56 Re: Ranking search results using multiple fields in PostgreSQL fulltext search
Previous Message Peter Eisentraut 2009-10-12 12:44:03 Re: auth problem