Re: select * from (select * from bob) and other easy stuff

Hi, right. This is the correct solution (or one might say workaround) for this known "problem". The functionality is there, but the syntax is somewhat akward. I think there's something in the works to improve this particular syntax in the future. Regards, Martin -- Martin Fuerderer IBM Informix Development Munich, Germany Information Management Informix URLs list: http://home.arcor.de/mfu1/informix/urls.html Informix in the news: http://www.crn.com/sections/software/software.jhtml?articleId=193004835 IBM Information On Demand Global Conference October 15-20, 2006, Anaheim, California see http://www.ibm.com/events/informationondemand informix-list-bounces@iiug.org wrote on 26.09.2006 04:48:20: > > Why doesn't something simple like: > > select * from (select * from bob)> > work? > > SELECT * FROM TABLE(MULTISET(SELECT * FROM bob))> > > Also, if you do something like : > > select upper(bob) jane from sometable > > where jane = 'SMITH' > > order by jane > > it doesn't work either. It lets jane appear in the order by, but not > > the where clause. > > So how are you supposed to limit your results based off of aliased > > (virtual) columns? This comes up for pretty much any time you use a > > function against a column to get some result ("decode" is what I am > > working with at the moment). > > > _______________________________________________ > Informix-list mailing list > Informix-list@iiug.org > http://www.iiug.org/mailman/listinfo/informix-list