From: Tim Perdue <tim@perdue.net>
To: pgsql-sql@postgresql.org
Subject: Full outer join
Date: Thu, 12 Apr 2001 13:09:50 -0500
Message-ID: <20010412130950.O446@mail.perdue.net> (raw)
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
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients from your mail client; the link fills in
the headers below: reply via email
Some clients, webmail especially, drop In-Reply-To and References from
a link, and the reply then starts a new thread: use the mbox below.
To: pgsql-sql@postgresql.org
Cc: tim@perdue.net
Subject: Re: Full outer join
In-Reply-To: <20010412130950.O446@mail.perdue.net>
References: <20010412130950.O446@mail.perdue.net>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox