Tyler Kellen <tyler@sleekcode.net> writes:
> I have a question about a full outer join returning duplicate rows.
Why do you think they are duplicate? The GROUP BY includes many columns
that you can't see directly in the output ...
Also, you did not show us the actual input data (where's the rows with
trans_item.parent=20116?)
regards, tom lane