While you can do a UNION of views, you can not do a VIEW of UNIONs.
This is OK:
select * from view1 UNION select * from view2;
This is not OK:
create view testv as select * from test1 UNION select * from test2;
Does the standard allow this? Thomas? I currently print a 'not
implemented' message.
Informix does not allow it, and I can't figure out how to do it with the
re-write system yet.
--
Bruce Momjian
maillist@candle.pha.pa.us