You are right as usual.... My apologies yet again. I have wrongly assumed that the lower statement would run first since it is enclosed in parenthesis.
On Tue, 2006-12-19 at 00:48 -0500, Tom Lane wrote: > mike <[EMAIL PROTECTED]> 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 > > ---------------------------(end of broadcast)--------------------------- > TIP 5: don't forget to increase your free space map settings ---------------------------(end of broadcast)--------------------------- TIP 6: explain analyze is your friend