Re: Full outer join

Tim Perdue <tim@perdue.net> 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