Re: [BUGS] execute incorect query and get data

#1

=?ISO-8859-2?Q?Marek_Wr=F3bel?= <mwrobel (AT) icentrum (DOT) pl> writes:

Quote:

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

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

Re: [BUGS] execute incorect query and get data

mailing.database.pgsql-bugs mailing.database.pgsql-bugs

Re: [BUGS] execute incorect query and get data - 12-14-2006 , 10:25 AM