Re: mergejoin error message executing in 7.2

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: "kevin rowe" <kevin(at)mtel(dot)co(dot)uk>
Cc: pgsql-sql(at)postgresql(dot)org
Subject: Re: mergejoin error message executing in 7.2
Date: 2003-07-01 22:32:18
Message-ID: 22610.1057098738@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-sql

"kevin rowe" <kevin(at)mtel(dot)co(dot)uk> writes:
> I have a problem trying to execute a complex query that was designed in
> 7.3.2 to a machine running 7.2.x
> this is the error message
> FULL JOIN is only supported with mergejoinable join conditions

Nested FULL JOINs don't work in 7.2.*. The fix is not practical to
back-port, so you're stuck: either modify the query to avoid that,
or update the machine with the older server.

regards, tom lane

In response to

Browse pgsql-sql by date

  From Date Subject
Next Message Joe Conway 2003-07-01 23:31:42 Re: LEAST and GREATEST functions?
Previous Message Joe Conway 2003-07-01 20:22:55 Re: LEAST and GREATEST functions?