Re: SQL construct not supported in informix ?

Thanks, usefull information. Chucho! Kristofer Andersson wrote: > Jean Sagi <jeansagi@myrealbox.com> wrote in message news:<bfj7tu$dre$1@terabinaries.xmission.com>... > >>Intereting... >> >>Does it work in IDS 9.3 too? > > > Yes, I have used it on 9.3 and 9.4. > > >>I think the same could be achieved by creating a temporary table: >> >>select col1 as a, col2 as b from mytable into temp tx with no log; >>select a,b from tx;> > > Yes, the "table(multiset(" will usually (or maybe even always?) result > in a temp table. > > >>Questions: >> >>- Wich is better? > > > Probably a matter of taste. > > >>- Why I may want to use a FROM like that? > > > In the example in the previous post there is no reason. But if you > want to join sets of aggregated data, it is very useful, or filter > down the results before joining. Don't use it if you don't have to. > > -- Atte, Jes's Antonio Santos Giraldo jeansagi@myrealbox.com jeansagi@netscape.net sending to informix-list