=?ISO-8859-2?Q?Marek_Wr=F3bel?= <[EMAIL PROTECTED]> writes:
> create table a (a1 integer);
> create table b (b1 integer);
> insert into a (a1) values (1);
> insert into a (a1) values (2);
> select a1 from b;
> ERROR: column "a1" does not exist at character 8
> but :
> select a1 from a where a1 not in (select a1 from b);
This is not a bug, it's an outer reference. Read any SQL book ...
regards, tom lane
---------------------------(end of broadcast)---------------------------
TIP 5: don't forget to increase your free space map settings
