X-Original-To: pgsql-sql-postgresql.org@localhost.postgresql.org
Received: from localhost (unknown [64.117.224.193])
	by svr1.postgresql.org (Postfix) with ESMTP id 3B787310D70
	for <pgsql-sql-postgresql.org@localhost.postgresql.org>;
	Tue,  1 Jul 2003 22:32:32 +0000 (GMT)
Received: from svr1.postgresql.org ([64.117.224.193])
	by localhost (svr1.postgresql.org [64.117.224.193]) (amavisd-new,
	port 10024) with ESMTP id 43414-10
	for <pgsql-sql-postgresql.org@localhost.postgresql.org>;
	Tue,  1 Jul 2003 19:32:21 -0300 (ADT)
Received: from sss.pgh.pa.us (unknown [192.204.191.242])
	by svr1.postgresql.org (Postfix) with ESMTP id 62D5D310D33
	for <pgsql-sql@postgresql.org>; Tue,  1 Jul 2003 19:32:21 -0300 (ADT)
Received: from sss2.sss.pgh.pa.us (tgl@localhost [127.0.0.1])
	by sss.pgh.pa.us (8.12.9/8.12.9) with ESMTP id h61MWIQQ022611;
	Tue, 1 Jul 2003 18:32:18 -0400 (EDT)
To: "kevin rowe" <kevin@mtel.co.uk>
Cc: pgsql-sql@postgresql.org
Subject: Re: mergejoin error message executing in 7.2 
In-reply-to: <000701c33fc1$b83dc600$3401a8c0@kevin> 
References: <000701c33fc1$b83dc600$3401a8c0@kevin>
Comments: In-reply-to "kevin rowe" <kevin@mtel.co.uk>
	message dated "Tue, 01 Jul 2003 12:12:16 +0100"
Date: Tue, 01 Jul 2003 18:32:18 -0400
Message-ID: <22610.1057098738@sss.pgh.pa.us>
From: Tom Lane <tgl@sss.pgh.pa.us>
X-Archive-Number: 200307/26
X-Sequence-Number: 14140

"kevin rowe" <kevin@mtel.co.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