Chris
Christopher Kings-Lynne wrote:
What's going on here:
usa=> select user_id from users_users where joindate >= '2004-03-09'; ERROR: column "user_id" does not exist
usa=> select * from shop_orders where user_id in (select user_id from users_users where joindate >= '2004-03-09');
[waits and waits and waits...have to cancel]
^CCancel request sent
ERROR: canceling query due to user request
How come using a field that doesn't exist in the subquery actually works and doesn't cause a syntax error?
Chris
---------------------------(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
---------------------------(end of broadcast)--------------------------- TIP 4: Don't 'kill -9' the postmaster
