Harry Jackson wrote: > > The following sql statement fails because the column "user_id" does > not exist in the users table. > > =# select user_id from users WHERE username = 'blah'; > ERROR: column "user_id" does not exist > LINE 1: select user_id from users WHERE username = 'blah...... > ^ [...] > > =# delete from map_users_roles where user_id = (select user_id from > users WHERE username = 'blah'); > DELETE 33631 > [...] > > Still, this was quite a suprise to me and I would consider this a bug. > > Thoughts? It is not a bug, but it is one of the best examples why it is good to always qualify columns that I have ever seen! Yours, Laurenz Albe
