Thread

Views on UNIONs

Bruce Momjian <maillist@candle.pha.pa.us> — 1998-01-09T21:33:05Z

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