Skip site navigation (1)
Skip section navigation (2)
Peripheral Links
Header And Logo
|
Site Navigation
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: Thu, 14 Dec 2006 11:23:52 -0500
- Message-id: <21281.1166113432@sss.pgh.pa.us> <text/plain>
=?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
- Follow-Ups:
- Re: execute incorect query and get data
- From: Marek Wróbel
- Re: execute incorect query and get data
- References:
- execute incorect query and get data
- From: Marek Wróbel
- execute incorect query and get data
- Prev by Date: Re: the bug report form doesn't accepts the email address
- Next by Date: Re: Compiling problem on Solaris
- Previous by thread: execute incorect query and get data
- Next by thread: Re: execute incorect query and get data
- Indexes: