Christian Ullrich <chris@chrullrich.net> writes:
> Hm. That makes some sense, I guess. But is that true even if the reference in the subquery is not explicitly
qualified?"SELECT foo FROM test_table2" looks to me like it refers to that table pretty unequivocally.
This behavior is required by the SQL standard ...
regards, tom lane