Hi everybody, I've just run into a seemingly strange behaviour of postgresql and I'd like to know if it's normal or what.
I've got a table "operation" in which there _isn't_ any column "id_compte". So when i do : "select id_compte from operation where not compta_g5;" I have : "ERROR: column "id_compte" does not exist" Everything ok until now. But when i put this query inside another query, i don't have anymore the error message : select distinct id_operation from compte where id_compte in (select id_compte from operation where not compta_g5); No error message. The postgresql version is the debian one : 7.4.7-2 What do you think of that ? David -- [EMAIL PROTECTED] - tel: 01.46.47.21.33 - fax: 01.46.47.21.37 ---------------------------(end of broadcast)--------------------------- TIP 4: Don't 'kill -9' the postmaster