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

David Pradier wrote:
> Actually, the column "id_compte" is the primary key of the table "compte".
> The column "id_compte" doesn't exist in the table "operation".
> 
> But i still don't understand why there is no error message, could you
> explain a little more ?

I think it's intended for use in the WHERE clause:  SELECT a.* FROM a WHERE a1 IN (SELECT b3 FROM b WHERE b2=a2)

--   Richard Huxton  Archonet Ltd