>> i was writing the query below containing a subquery. by mistake, i
>> referenced a field from the main table in the subquery, leading to a
>> very strange (but working??) result. the planner announced a insanely
>> high startup cost, but the query itself finished pretty quickly.
>>
>
> Pick up any SQL book and read up on correlated subqueries.
>
> Have a nice day,
>
thanks! i didn't knew this term. the result is pretty obvious now, and
so is the high cost prediction.
regards,
thomas