Thread: problem with union and outer join using a view

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

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