Re: Full outer join

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

I've committed a fix for this problem.  It'll appear in 7.1.1, or you
can grab CVS or a nightly snapshot if you are in a hurry.
        regards, tom lane