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

Reply via email to