Re: [GENERAL] FULL JOIN and mergjoinable conditions...

2004-06-29 Thread Tom Lane
Martijn van Oosterhout <[EMAIL PROTECTED]> writes: > Today I got the error: > ERROR: FULL JOIN is only supported with mergejoinable join conditions > Which is really annoying since a full join is exactly what I wanted. I > guess the alternative is to do a left join and a right join and merge > the

[GENERAL] FULL JOIN and mergjoinable conditions...

2004-06-29 Thread Martijn van Oosterhout
Today I got the error: ERROR: FULL JOIN is only supported with mergejoinable join conditions Which is really annoying since a full join is exactly what I wanted. I guess the alternative is to do a left join and a right join and merge them? Is it just that no-one has come up with a way to code th