Views on UNIONs

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(at)candle(dot)pha(dot)pa(dot)us