Thread: 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.  :-)

create view testv as
select * from dual
union all
select * from dual;

Works in Oracle, I think this is great, I have been missing this feature in
Informix.
It can for example solve the large table problem (create several tables and
a union view).
But it is definitely a goody that could wait a little on the TODO list.

Andreas

> Works in Oracle, I think this is great, I have been missing this feature in
> Informix.
> It can for example solve the large table problem (create several tables and
> a union view).
> But it is definitely a goody that could wait a little on the TODO list.

Added to TODO.

--
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)