Re: mergejoin error message executing in 7.2 - Mailing list pgsql-sql

"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