mike <mike(at)thegodshalls(dot)com> writes:
> Pgsql does not throw an error (at least prior to 8.2) if the column
> referenced by the select statement for the IN clause does not exist.
My, there's a lot of misinformation in this thread.
The reason there's no error thrown is that the reference to mov_id in
the sub-SELECT is a perfectly legal outer reference to the mov_id column
available from the upper SELECT. If the column truly did not exist
anywhere in the tables used in the query, it would have thrown an error.
regards, tom lane