On Thu, Nov 08, 2007 at 09:35:19PM +0100, Thomas H. wrote:
> 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,
--
Martijn van Oosterhout <kleptog@svana.org> http://svana.org/kleptog/
> Those who make peaceful revolution impossible will make violent revolution inevitable.
> -- John F Kennedy