Thread

1. problem with union and outer join using a view

   Merrill Oveson <merrill@actarg.com> — 2000-07-05T16:04:27Z

   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
   
   
   

2. Re: problem with union and outer join using a view

   Tom Lane <tgl@sss.pgh.pa.us> — 2000-07-05T17:21:27Z

   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