Path: utzoo!utgpu!news-server.csri.toronto.edu!rutgers!netnews.upenn.edu!grad2.cis.upenn.edu!aaron From: aaron@grad2.cis.upenn.edu (Aaron Watters) Newsgroups: comp.databases Subject: Union and Views Message-ID: <27663@netnews.upenn.edu> Date: 1 Aug 90 14:06:05 GMT Sender: news@netnews.upenn.edu Reply-To: aaron@grad2.cis.upenn.edu.UUCP (Aaron Watters) Distribution: usa Organization: University of Pennsylvania Lines: 17 I recently volunteered some consulting for a friend about a difficult database problem. The solution we came up with was unduely complex because of the following weird restriction: In Informix, for example, Unions are not allowed in the definitions of Views. Why is this? Do other systems have this restriction? How can system implementers look themselves in the mirror when they impose such arbitrary restrictions on their customers? Please respond directly to me, as I tend to lose track of this hyperactive newsgroup. -aaron << It's amazing how sophisticated triviality has become.>> -Lakatos.