On Mon, 27 Jan 2003, Jean-Luc Lachance wrote:
> There is no error reported when a field in the subselect is not part of
> the subselect table
> but exists in the main table.
>
> Try This:
>
> nsd=# create table a ( f1 int, f2 text);
> CREATE
> nsd=# create table b ( f3 int, f4 text);
> CREATE
> nsd=# select * from a where f1 in ( select f1 from b);
> f1 | f2
> ----+----
> (0 rows)
That's because f1 is taken as an outer reference. I think
that's the expected/correct behavior.
---------------------------(end of broadcast)---------------------------
TIP 2: you can get off all lists at once with the unregister command
(send "unregister YourEmailAddressHere" to [EMAIL PROTECTED])
