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

Re: BUG #4250: subquery in query

From: "Kevin Grittner" <Kevin(dot)Grittner(at)wicourts(dot)gov>
To: <pgsql-bugs(at)postgresql(dot)org>,"Wojciech Tylek" <wat(at)wat(dot)net(dot)pl>
Subject: Re: BUG #4250: subquery in query
Date: 2008-06-17 21:55:54
Message-ID: 4857EC54.EE98.0025.0@wicourts.gov (view raw or flat)
Thread:
Lists: pgsql-bugs
>>> "Wojciech Tylek" <wat(at)wat(dot)net(dot)pl> wrote: 
 
> Why the query like:
> 
> select * from b where a_id in (select a_id from a where b_id in
(10,20));
> 
> does not return error?
> The table "a" does not have b_id! 
 
This is a correlated subquery.  A previous list post on the topic:
 
http://archives.postgresql.org/pgsql-general/2007-06/msg01659.php
 
I hope this helps.
 
-Kevin

In response to

pgsql-bugs by date

Next:From: Andreas AnderssonDate: 2008-06-18 01:07:37
Subject: BUG #4252: SQL stops my graic cards
Previous:From: Wojciech TylekDate: 2008-06-17 20:37:24
Subject: BUG #4250: subquery in query

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