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)