"Adam Buchbinder" <adam(at)support(dot)uroweb(dot)net> writes:
> Run these queries:
> SELECT otherfield FROM joinview WHERE fname='Quux';
> SELECT otherfield FROM firsttab WHERE otherfield IN (SELECT otherfield FROM
> joinview WHERE fname='Quux');
> SELECT otherfield FROM firsttab WHERE otherfield IN (SELECT otherfield FROM
> joinview WHERE fname='Bar');
> The first query returns an error, but the other two do not;
This is not a bug, it's a standard outer-reference construction. See
any SQL book for details.
regards, tom lane