Skip site navigation (1) Skip section navigation (2)

Re: execute incorect query and get data

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: Marek Wróbel <mwrobel(at)icentrum(dot)pl>
Cc: pgsql-bugs(at)postgresql(dot)org
Subject: Re: execute incorect query and get data
Date: 2006-12-14 16:23:52
Message-ID: 21281.1166113432@sss.pgh.pa.us (view raw or flat)
Thread:
Lists: pgsql-bugs
=?ISO-8859-2?Q?Marek_Wr=F3bel?= <mwrobel(at)icentrum(dot)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 ...

			regards, tom lane

In response to

Responses

pgsql-bugs by date

Next:From: Zdenek KotalaDate: 2006-12-14 17:02:30
Subject: Re: Compiling problem on Solaris
Previous:From: Magnus HaganderDate: 2006-12-14 13:41:38
Subject: Re: the bug report form doesn't accepts the email address

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group