Postgres Pro
Downloads
Home   >   mailing lists

Re: Rank based on the number of matching OR fields? - Mailing list pgsql-general

From François Beausoleil
Subject Re: Rank based on the number of matching OR fields?
Date
Msg-id DB506A88-B843-426C-96AC-05284B8804FD@teksol.info
Whole thread Raw
In response to Rank based on the number of matching OR fields?  ("W. Matthew Wilson" <matt@tplus1.com>)
List pgsql-general
Tree view

Le 2012-09-25 à 14:16, W. Matthew Wilson a écrit :

I want to run a query like to_tsquery("A | B | C") and then rank the
results so that if a document contained A, B, and C, then it would
rank above a document that just had some subset.

How would I do such a thing?

http://www.postgresql.org/docs/current/static/textsearch-controls.html#TEXTSEARCH-RANKING

Hope that helps,
François Beausoleil

pgsql-general by date:

Previous
From: "W. Matthew Wilson"
Date:
Subject: Rank based on the number of matching OR fields?
Next
From: Scot Kreienkamp
Date:
Subject: idle in transaction query makes server unresponsive