problem with union and outer join using a view
Started by Merrill Ovesonalmost 26 years ago2 messagesbugs
Developers:
I need to create a view that contains a query with an outer join.
Since outer joins are not supported, I used a union.
The problem, now, is that unions are not supported with views.
How soon until this is fixed?
Any suggestions?
Merrill
Re: problem with union and outer join using a view
Merrill Oveson <merrill@actarg.com> writes:
How soon until this is fixed?
The plans are to fix it in 7.2, which might be half a year or so away.
Any suggestions?
For now, don't use a view. Perhaps you can embed the query in a
function or something so that you don't have to look at it ...
regards, tom lane