Re: Having Union clause in a view

Jonathan Leffler wrote in message <6mtrbl$ovi$1@news.xmission.com>... > >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. Yipeeee! I was going through the release notes last night and there are some nice additions in 7.30 such as UPPER and LOWER ( how long have we waited for this?). > >Yours, >Jonathan Leffler (jleffler@informix.com) #include <witticism.h> >Guardian of DBD::Informix -- see http://www.perl.com/CPAN >