This is not a bug; given your test queries whenever you reference ?id1? you are ALWAYS referencing the column ?id1? in table ?test2?. >>test=# select * from test2 where id1 in (select id1 from test1) and charge=70; >> id1 | charge >>-----+-------- >> 10 | 70 >> (1 row) Hint: Consider the results of: SELECT ?literal? FROM table1; AND SELECT t1.*, (SELECT t2.col2 FROM t2 WHERE t2.id = t1.id) FROM t1; David J. -- Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
