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
--
dpradier(at)apartia(dot)fr - tel: 01.46.47.21.33 - fax: 01.46.47.21.37