"kevin rowe" <[EMAIL PROTECTED]> 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 ---------------------------(end of broadcast)--------------------------- TIP 3: if posting/reading through Usenet, please send an appropriate subscribe-nomail command to [EMAIL PROTECTED] so that your message can get through to the mailing list cleanly