Re: execute incorect query and get data - Mailing list pgsql-bugs

From Marek Wróbel
Subject Re: execute incorect query and get data
Date
Msg-id 45826457.1000804@icentrum.pl
Whole thread Raw
In response to Re: execute incorect query and get data  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-bugs
Him,

Tom Lane napisał(a):
> Marek Wróbel <mwrobel@icentrum.pl> 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 ...

of course... so sorry... I was such startled off result off this query,
that I can't see that...


pgsql-bugs by date:

Previous
From: "CN Liou"
Date:
Subject: BUG #2827: AV occurs to libpq with newer versions of wine
Next
From: ""
Date:
Subject: BUG #2830: Wrong results for prepared statements while clustering target table