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

Tue, 24 Feb 1998 09:56:24 +0100
Zeugswetter Andreas SARZ <Andreas.Zeugswetter@telecom.at>
Re: [HACKERS] Views on aggregates - need assistence
> 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)

Tue, 24 Feb 1998 10:07:57 -0500 (EST)
Bruce Momjian <maillist@candle.pha.pa.us>
Re: [HACKERS] Views on aggregates - need assistence