Re: Why no union in view select statement?

Posted in 1995

Jonathan Leffler — 31 Aug 1995 18:53:03 -0400 — source: Informix-list mailing list archive (1991-1998)

ANSI SQL-89 does not require UNION views. Informix 5 and 6 do not allow it. The 7.1 manual also says it is not allowed. It is a common extension of ANSI SQL, but it is an extension. SQL-92 does require UNION views. Informix only claims entry-level conformance to SQL-92, which does not require UNION views. Yours, Jonathan Leffler (johnl@informix.com) #include <disclaimer.h> >From: rainer@PROBLEM_WITH_INEWS_GATEWAY_FILE.informix.com (Rainer Staringer) >Date: 31 Aug 1995 18:21:17 GMT >X-Informix-List-Id: <news.16687> > >Can anybody tell me why it isn't possible to define a view over a union >of select statements on different tables? At least Informix 5.0 cannot >do that. Is it possible in Informix 7.0? What does the SQL standard have >to say about this topic? > >Rainer Staringer >rainer@fml.tuwien.ac.at