X-Original-To: pgsql-sql-postgresql.org@localhost.postgresql.org Received: from localhost (av.hub.org [200.46.204.144]) by svr1.postgresql.org (Postfix) with ESMTP id F311FD966A for ; Fri, 14 Oct 2005 15:28:30 -0300 (ADT) Received: from svr1.postgresql.org ([200.46.204.71]) by localhost (av.hub.org [200.46.204.144]) (amavisd-new, port 10024) with ESMTP id 62427-09 for ; Fri, 14 Oct 2005 18:28:25 +0000 (GMT) Received: from sss.pgh.pa.us (sss.pgh.pa.us [66.207.139.130]) by svr1.postgresql.org (Postfix) with ESMTP id 98C70D965F for ; Fri, 14 Oct 2005 15:28:25 -0300 (ADT) Received: from sss2.sss.pgh.pa.us (tgl@localhost [127.0.0.1]) by sss.pgh.pa.us (8.13.1/8.13.1) with ESMTP id j9EISO3s024217; Fri, 14 Oct 2005 14:28:24 -0400 (EDT) To: tyler@sleekcode.net Cc: pgsql-sql@postgresql.org Subject: Re: FULL OUTER JOIN Question In-reply-to: <2005101413239.933110@devbox> References: <2005101413239.933110@devbox> Comments: In-reply-to Tyler Kellen message dated "Fri, 14 Oct 2005 13:02:39 -0500" Date: Fri, 14 Oct 2005 14:28:24 -0400 Message-ID: <24216.1129314504@sss.pgh.pa.us> From: Tom Lane X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, hits=0.006 required=5 tests=[AWL=0.006] X-Spam-Level: X-Archive-Number: 200510/174 X-Sequence-Number: 23027 Tyler Kellen 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