"Nicholas" <hb(at)x256(dot)com> writes:
> SELECT cgm.id, g.name, mi.invitees FROM meeting_instances as mi JOIN
> meeting_versions as m ON m.iid = '33' JOIN groups as g ON g.id = m.team LEFT
> JOIN cachedgroupmembers as cgm ON cgm.groupid = m.team and not cgm.disabled
> and cgm.memberid = '55' WHERE mi.id = '33';
> ERROR: variable not found in subplan target list
Could we see a *complete* example please? I have no time or interest
to guess about the tables underlying this view.
regards, tom lane