Shachar Shemesh <[EMAIL PROTECTED]> writes: > I thought about doing something like this: > select |COALESCE(table1.field, table2.field) as field from table1 full > outer join table2 on false
Perhaps you are looking for UNION ALL? If not, I'm not sure what you expect this query to mean. regards, tom lane ---------------------------(end of broadcast)--------------------------- TIP 4: Don't 'kill -9' the postmaster