Shachar Shemesh <psqll(at)shemesh(dot)biz> 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