Re: [HACKERS] Views on aggregates - need assistence

>
> On Mon, 23 Feb 1998, Bruce Momjian wrote:
>
> > Actually, it does handle unions of views, but not views of unions.
> > Informix doesn't support it either, and I don't know what the other
> > dbms's do, but I think I am going to find out soon from someone. :-)
>
> What exactly would you like me to try here? *raised eyebrow*
>
>
>

create view as
select oid from pg_user union select oid from pg_class

or something like that. That will not work under PostgreSQL. But you
can use views as part of a union:

select oid from view1
union
select oid from view2

--
Bruce Momjian | 830 Blythe Avenue
maillist(at)candle(dot)pha(dot)pa(dot)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)