Re: [SQL] mergejoin error message executing in 7.2

2003-07-01 Thread Tom Lane
"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

[SQL] mergejoin error message executing in 7.2

2003-07-01 Thread kevin rowe
hi there, 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 this is the source string for a jdbc prepared statement. (it has ordering clause added at t