Re: [BUGS] BUG #4250: subquery in query

2008-06-17 Thread Kevin Grittner
>>> "Wojciech Tylek" <[EMAIL PROTECTED]> 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://arch

[BUGS] BUG #4250: subquery in query

2008-06-17 Thread Wojciech Tylek
The following bug has been logged online: Bug reference: 4250 Logged by: Wojciech Tylek Email address: [EMAIL PROTECTED] PostgreSQL version: 8.1,8.2,8.3 Operating system: Linux Description:subquery in query Details: There are two example tables: create table a (