Re: select * from (select * from bob) and other easy stuff
Posted in 2006
Topics: General Discussion
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