"Adam Buchbinder" <[EMAIL PROTECTED]> 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
---------------------------(end of broadcast)---------------------------
TIP 4: Have you searched our list archives?
http://archives.postgresql.org
