Received: from redbox.venux.net (redbox.venux.net [216.47.238.10])
	by hub.org (8.9.2/8.9.1) with ESMTP id UAA95442
	for <pgsql-interfaces@postgreSQL.org>;
	Tue, 13 Apr 1999 20:23:07 -0400 (EDT)
	(envelope-from matthew@venux.net)
Received: from thunder (net177138.hcv.com [209.153.177.138])
	by redbox.venux.net (Postfix) with SMTP for
	<pgsql-interfaces@postgreSQL.org>
	id 540122E210; Tue, 13 Apr 1999 20:22:26 -0400 (EDT)
Message-Id: <4.1.19990413201455.00a904a0@mail.venux.net>
X-Sender: mhagerty@mail.venux.net
X-Mailer: QUALCOMM Windows Eudora Pro Version 4.1 
Date: Tue, 13 Apr 1999 20:22:24 -0400
To: pgsql-interfaces@postgreSQL.org
From: Matthew Hagerty <matthew@venux.net>
Subject: Weighted Searchs
Mime-Version: 1.0
Content-Type: text/plain; charset="us-ascii"

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