Re: Erratic error message "ERROR: column "id_compte" does - Mailing list pgsql-hackers

David Pradier wrote:
> 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.

It looks like it's binding to the outer query - where you seem to have 
an id_compte.

--  Richard Huxton  Archonet Ltd