Hi list,
I need to create a list of all rows of the combination of two tables. For reasons I can't go into, I need this list to be in a single query, and not write a function to do it.
I thought about doing something like this:
select |COALESCE(table1.field, table2.field) as field from table1 full outer join table2 on false
There is just one small problem. Even though logically this does what I'm trying to do, postgres says:
"FULL JOIN is only supported with merge-joinable conditions".
I don't even understand the error message, much less whether I'm doing anything wrong, and whether I'm missing something stupifyingly obvious here.
Help?
Postgres version is 7.4
Shachar |
-- Shachar Shemesh Lingnu Open Source Consulting ltd. http://www.lingnu.com/
---------------------------(end of broadcast)--------------------------- TIP 7: don't forget to increase your free space map settings
