en run in isolation, you get a non-empty result set, so there seems to
be a problem with the subselect.
If you need any other information to decide whether this is one of the known
bugs or a new one, just let me know what exactly you need. I can provide a
backup of the three tables in question
I'm not sure if I'm making wrong assumptions on the semantics of
subselect or if this a problem in PostgreSQL:
I'm using query with the following structure
select a1.id, c1.foo
from a as a1
join b on ...
join c as c1 on ...
where a.id in (
select a2.id
from a as a2
left join c as c2
