On Jan 30, 2004, at 11:00 AM, David Teran wrote:
executing a select like this:
select sum(job_property_difference(t0.int_value, t1.int_value)) as rank from job_property t0, job_property t1 where t0.id_job_profile = 911 and t0.id_job_attribute = t1.id_job_attribute and t1.id_job_profile in (select id_job_profile from unemployed) and t1.id_job_profile <> 911;
results in a query plan result:
What's the goal here? Are you trying to rank by how the int_value relates to each other? I'd like to know more about what kind of result you're trying to achieve.
-- PC Drew
---------------------------(end of broadcast)--------------------------- TIP 1: subscribe and unsubscribe commands go to [EMAIL PROTECTED]
