Re: No error when FROM is missing in subquery

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 <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
>
> ---------------------------(end of broadcast)---------------------------
> TIP 5: don't forget to increase your free space map settings