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@candle.pha.pa.us