Re: Strange behavior on non-existent field in subselect? - Mailing list pgsql-general

Thanks for the response Ragnar.  I would have expected this query to
fail, since the sub-query doesn't work by itself:

>> SELECT foo_field FROM foo WHERE foo_field IN (SELECT foo_field FROM par);

But it obviously doesn't.  So does that subselect implicitly read as:

IN (SELECT foo_field FROM par,foo);

Thanks for your help!

Ken