Thread: Weighted Searchs

Weighted Searchs

From
Matthew Hagerty
Date:
Greetings,

Is it possible to do a "weighted search" with postgres?  A weighted search
would be like a [select] with a [where] clause with a bunch of conditions.
Each condition is worth 1 point.  So if 6 conditions match, that would be
60%, etc.  The results would be shown highest points first.  Almost like a
search engine, the more I think about it.  Hmm.

How is this done?  Or more to the point, how can I do this with postgres?

Thanks,
Matthew