Thread

1. Re: [HACKERS] Views on aggregates - need assistence

   Zeugswetter Andreas IZ5 <andreas.zeugswetter@telecom.at> — 1998-02-24T08:56:24Z

   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
   
   

2. Re: [HACKERS] Views on aggregates - need assistence

   Bruce Momjian <maillist@candle.pha.pa.us> — 1998-02-24T15:07:57Z

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