Re: Full outer join

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: Tim Perdue <tim(at)perdue(dot)net>
Cc: pgsql-sql(at)postgresql(dot)org
Subject: Re: Full outer join
Date: 2001-04-15 00:50:52
Message-ID: 24870.987295852@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-sql

Tim Perdue <tim(at)perdue(dot)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

In response to

Browse pgsql-sql by date

  From Date Subject
Next Message Lonnie Cumberland 2001-04-15 00:53:26 Re: cpp Makefiles
Previous Message Lonnie Cumberland 2001-04-15 00:46:15 g++ not working for postgresql extension languages?