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 <[EMAIL PROTECTED]> http://svana.org/kleptog/ > Those who make peaceful revolution impossible will make violent revolution > inevitable. > -- John F Kennedy
signature.asc
Description: Digital signature
