Postgres Pro
Downloads
Home   >   mailing lists

Re: Full outer join - Mailing list pgsql-sql

From Tom Lane
Subject Re: Full outer join
Date
Msg-id 24870.987295852@sss.pgh.pa.us
Whole thread Raw
In response to Full outer join  (Tim Perdue <tim@perdue.net>)
List pgsql-sql
Tree view 
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

pgsql-sql by date:

Previous
From: Lonnie Cumberland
Date:
Subject: g++ not working for postgresql extension languages?
Next
From: "Sergey E. Volkov"
Date:
Subject: Same question about PostgreSql