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

Fri, 9 Jan 1998 16:33:05 -0500 (EST)
Bruce Momjian <maillist@candle.pha.pa.us>
Views on UNIONs