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 f3CIBB852148 for ; Thu, 12 Apr 2001 14:11:12 -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 f3CI9o613766 for pgsql-sql@postgresql.org; Thu, 12 Apr 2001 13:09:50 -0500 Date: Thu, 12 Apr 2001 13:09:50 -0500 From: Tim Perdue To: pgsql-sql@postgresql.org Subject: Full outer join Message-ID: <20010412130950.O446@mail.perdue.net> Mime-Version: 1.0 Content-Type: text/plain; charset=us-ascii Content-Disposition: inline User-Agent: Mutt/1.3.12i X-Archive-Number: 200104/178 X-Sequence-Number: 2526 Looking at the docs for 7.1, it appears that full outer joins are supported: http://www.postgresql.org/devel-corner/docs/user/queries.html However, I keep getting this error, and I don't know what it means: ERROR: FULL JOIN is only supported with mergejoinable join conditions I've tried several variations and keep getting the same error. Anyone have any ideas? Details below. Thanks, Tim 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 SELECT day,filerelease_id 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 alexandria=# \d stats_http_downloads Table "stats_http_downloads" Attribute | Type | Modifier ----------------+---------+---------------------- day | integer | not null default '0' filerelease_id | integer | not null default '0' group_id | integer | not null default '0' downloads | integer | not null default '0' alexandria=# \d stats_ftp_downloads Table "stats_ftp_downloads" Attribute | Type | Modifier ----------------+---------+---------------------- day | integer | not null default '0' filerelease_id | integer | not null default '0' group_id | integer | not null default '0' downloads | integer | not null default '0' -- Founder - PHPBuilder.com / Geocrawler.com Lead Developer - SourceForge VA Linux Systems