On Fri, 30 Jan 2004, David Teran wrote:
> 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:
Can we see explain analyze output for the query, it'll give more
information about actual time and row counts than plain explain.
---------------------------(end of broadcast)---------------------------
TIP 9: the planner will ignore your desire to choose an index scan if your
joining column's datatypes do not match
