"Scott Dunbar" <sc...@xigole.com> writes:
> I have a nested in clause like:
> select respondent_id from respondent where respondent_id in (select
> respondent_id from chat_session where project_id in (select project_id from
> project where company_id = 4));
> However, in this example, there is no column named respondent_id in the
> chat_session table.
Probably there is one in respondent, though? This behavior is not a bug
--- what you have there is an outer reference, and it is working exactly
as specified by the SQL standard. Sub-selects would be a whole lot less
useful if they couldn't refer to variables of the outer query.
regards, tom lane
--
Sent via pgsql-bugs mailing list (pgsql-bugs@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-bugs
