Received: from sss.pgh.pa.us ([216.151.103.158]) by postgresql.org (8.11.3/8.11.1) with ESMTP id f3D72f864908 for ; Fri, 13 Apr 2001 03:02:42 -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 f3D72WR03107; Fri, 13 Apr 2001 03:02:33 -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: Fri, 13 Apr 2001 03:02:32 -0400 Message-ID: <3104.987145352@sss.pgh.pa.us> From: Tom Lane X-Archive-Number: 200104/191 X-Sequence-Number: 2541 Tim Perdue writes: > However, I keep getting this error, and I don't know what it means: > ERROR: FULL JOIN is only supported with mergejoinable join conditions Works for me: regression=# create table stats_http_downloads (day int, filerelease_id int); CREATE regression=# create table stats_ftp_downloads (day int, filerelease_id int); CREATE regression=# SELECT * FROM (stats_http_downloads sh regression(# FULL OUTER JOIN stats_ftp_downloads sf USING (day,filerelease_id)); day | filerelease_id -----+---------------- (0 rows) What version are you using? regards, tom lane