Re: [GENERAL] Mysterious query plan

2005-09-27 Thread Tom Lane
"John D. Burger" <[EMAIL PROTECTED]> writes: > I mistyped a table name in the following query: >select * from gazContainers > where gazPlaceID in (select gazPlaceID from tipsterAuxiliary); > Turns out there's no gazPlaceID column in tipsterAuxiliary, so the > inner gazPlaceID was refe

[GENERAL] Mysterious query plan

2005-09-27 Thread John D. Burger
Hi - I mistyped a table name in the following query: select * from gazContainers where gazPlaceID in (select gazPlaceID from tipsterAuxiliary); Turns out there's no gazPlaceID column in tipsterAuxiliary, so the inner gazPlaceID was referring to the outer gazContainers table. This