Erratic error message "ERROR: column "id_compte" does not exist"

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@apartia.fr - tel: 01.46.47.21.33 - fax: 01.46.47.21.37