ue, 12 Sep 2000, Mitch Vincent wrote:
> Date: Tue, 12 Sep 2000 09:22:12 -0700
> From: Mitch Vincent <[EMAIL PROTECTED]>
> To: [EMAIL PROTECTED]
> Cc: [EMAIL PROTECTED]
> Subject: [SQL] Weighted Searching
>
> I emailed the list a while back about doing some weigh
Mr. Vincent,
> I emailed the list a while back about doing some weighted searching, asking
> if anyone had implemented any kind of weighted search in PostgreSQL.. I'm
> still wondering the same thing and if anyone has, I would greatly appreciate
> a private email, I'd like to discuss it in detail
I'm not sure how fast it is, but something like this
would work, right?
WHERE
(CASE WHEN degree='MBA' THEN 10 ELSE 0 END +
CASE WHEN years_experience='5' THEN 10 ELSE 0 END _
CASE WHEN location_state='Arizona' THEN 10 ELSE 0 END)
>=20
Also, wouldn't you usually want to be searching where the
w
I emailed the list a while back about doing some weighted searching, asking
if anyone had implemented any kind of weighted search in PostgreSQL.. I'm
still wondering the same thing and if anyone has, I would greatly appreciate
a private email, I'd like to discuss it in detail.. I have several idea
