Re: Create View with a UNION ?

Doug Agnew wrote: > > Well, > > That select can be implemented WITHOUT a union, so it may be the optimizer > is allowing it. The syntax of the CREATE VIEW command has nothing to do with the optimiser! That only kicks in when you run it. > SELECT tabid from systables Where tabid >50 or tabid<99> > is equivalent. It was an example of UNION syntax, which passed. > And, that is equivalent to : > SELECT tabid from systables. But that doesn't test the UNION syntax. UNION in a view was only introduced recently. Someone said 7.30, I think it was actually earlier. Cheers, -- Mark. +----------------------------------------------------------+-----------+ | Mark D. Stock mailto:mdstock@mydas.freeserve.co.uk |//////// /| | http://www.informix.com http://www.informixhandbook.com |///// / //| | http://www.iiug.org +-----------------------------------+//// / ///| | |What year 2000 bug? year 2000 bug? |/// / ////| | |year 2000 bug? year 2000 bug? year |// / /////| | |2000 bug? year 2000 bug? year 1900 |/ ////////| +----------------------+-----------------------------------+-----------+