Re: Having Union clause in a view

Posted in 1998

Art S. Kagel — Thu, 25 Jun 1998 13:20:06 -0400 — source: Informix-list mailing list archive (1991-1998)

Mahesh G wrote: > > Hi, > > I was getting a syntax error while creating a view that had 'union' clause. > I was surprised to read from the manual that it is not possible were as this > is > possible in Ingres and Oracle. > Is there any technical issues? I am willing to know why Informix cudn't > provide this > feature? They could and have in 7.3. The original ANSI SQL definition did not allow UNIONs in VIEWs and Informix, burdened by the guilt of having pushed for the ANSI standard in the first place, felt compelled to be more compliant than the rest. Art S. Kagel