Re: FULL OUTER JOIN Question

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: tyler(at)sleekcode(dot)net
Cc: pgsql-sql(at)postgresql(dot)org
Subject: Re: FULL OUTER JOIN Question
Date: 2005-10-14 18:28:24
Message-ID: 24216.1129314504@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-sql

Tyler Kellen <tyler(at)sleekcode(dot)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

In response to

Browse pgsql-sql by date

  From Date Subject
Next Message Dau Sy Manh 2005-10-15 02:38:58 Re: copy tables
Previous Message Dan Feiveson 2005-10-14 18:20:07 Re: cast