Re: [HACKERS] Views on aggregates - need assistence

> > can use views as part of a union:
> > 
> > 	select oid from view1
> > 	union
> > 	select oid from view2
> 
> You mean like:
> 
> SQL> select * from one
>   2  ;
> 
>          A
> ----------
>          3
>          4
>          2
> 
> SQL> create table two ( B int );
> 
> Table created.
> SQL> create view v1 as select A from one union select B from two;
> 
> View created.
> 
> SQL> select * from v1;
> 
>          A
> ----------
>          1
>          2
>          3
>          4
> 

Yep, we can't currently do that.

-- 
Bruce Momjian                          |  830 Blythe Avenue
maillist@candle.pha.pa.us              |  Drexel Hill, Pennsylvania 19026
  +  If your life is a hard drive,     |  (610) 353-9879(w)
  +  Christ can be your backup.        |  (610) 853-3000(h)