Re: Having Union clause in a view

Posted in 1998

Jonathan Leffler — Thu, 25 Jun 1998 08:31:57 -0700 (PDT) — source: Informix-list mailing list archive (1991-1998)

On Thu, 25 Jun 1998, Mahesh G wrote: > 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? Your primary problem is that you aren't using a version which allows it. The recently released 7.30 version of IDS does support UNION views. Yours, Jonathan Leffler (jleffler@informix.com) #include <witticism.h> Guardian of DBD::Informix -- see http://www.perl.com/CPAN