"Scott Dunbar" <scott@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