Received: from sss.pgh.pa.us ([216.151.103.158]) by postgresql.org (8.11.3/8.11.1) with ESMTP id f3F0owu71088 for ; Sat, 14 Apr 2001 20:50:58 -0400 (EDT) (envelope-from tgl@sss.pgh.pa.us) Received: from sss2.sss.pgh.pa.us (tgl@localhost [127.0.0.1]) by sss.pgh.pa.us (8.11.3/8.11.3) with ESMTP id f3F0orR24873; Sat, 14 Apr 2001 20:50:53 -0400 (EDT) To: Tim Perdue cc: pgsql-sql@postgresql.org Subject: Re: Full outer join In-reply-to: <20010412130950.O446@mail.perdue.net> References: <20010412130950.O446@mail.perdue.net> Comments: In-reply-to Tim Perdue message dated "Thu, 12 Apr 2001 13:09:50 -0500" Date: Sat, 14 Apr 2001 20:50:52 -0400 Message-ID: <24870.987295852@sss.pgh.pa.us> From: Tom Lane X-Archive-Number: 200104/231 X-Sequence-Number: 2581 Tim Perdue writes: > SELECT * > FROM (stats_http_downloads sh > FULL OUTER JOIN stats_ftp_downloads sf USING (day,filerelease_id)) ; > ERROR: FULL JOIN is only supported with mergejoinable join conditions I've committed a fix for this problem. It'll appear in 7.1.1, or you can grab CVS or a nightly snapshot if you are in a hurry. regards, tom lane