On Thu, Jul 21, 2016 at 9:53 PM, Robert Haas <robertmh...@gmail.com> wrote:
> It would need to be a Hash Semi Join rather than a Hash Join, wouldn't it? I guess, Hash Join will do here, because inner hash node is, on hash aggregate with group key on t2.id2, t2.c2 and hash join condition is (t1.id1 = t2.id2) AND (t1.c1 = t2.c2). So I think these together will make sure that we don't get duplicate tuple for one outer record. -- Regards, Dilip Kumar EnterpriseDB: http://www.enterprisedb.com