On Thu, Jul 21, 2016 at 9:53 PM, Robert Haas <robertmhaas(at)gmail(dot)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