Received: from mail.perdue.net (c696732-a.west1.ia.home.com [24.22.227.157]) by postgresql.org (8.11.3/8.11.1) with ESMTP id f3DDOu830654 for ; Fri, 13 Apr 2001 09:24:56 -0400 (EDT) (envelope-from tperdue@mail.perdue.net) Received: (from tperdue@localhost) by mail.perdue.net (8.11.2/8.11.2/Debian 8.11.2-1) id f3DDNNK15145; Fri, 13 Apr 2001 08:23:23 -0500 Date: Fri, 13 Apr 2001 08:23:22 -0500 From: Tim Perdue To: Tom Lane Cc: pgsql-sql@postgresql.org Subject: Re: Full outer join Message-ID: <20010413082322.W446@mail.perdue.net> References: <20010412130950.O446@mail.perdue.net> <3104.987145352@sss.pgh.pa.us> Mime-Version: 1.0 Content-Type: text/plain; charset=us-ascii Content-Disposition: inline User-Agent: Mutt/1.3.12i In-Reply-To: <3104.987145352@sss.pgh.pa.us>; from tgl@sss.pgh.pa.us on Fri, Apr 13, 2001 at 03:02:32AM -0400 X-Archive-Number: 200104/192 X-Sequence-Number: 2542 On Fri, Apr 13, 2001 at 03:02:32AM -0400, Tom Lane wrote: > 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 table stats_http_downloads (day int, filerelease_id int,group_id int, downloads int); > CREATE > regression=# create table stats_ftp_downloads (day int, filerelease_id int); create table stats_ftp_downloads (day int, filerelease_id int,group_id int, downloads 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? That's RC3 and RC1. I wonder if the problem is because stats_http_downloads and stats_ftp_downloads both have group_id and downloads, which I don't want to use as part of the join. Does it still work with those revised CREATE statements? Tim -- Founder - PHPBuilder.com / Geocrawler.com Lead Developer - SourceForge VA Linux Systems