Re: SQL construct not supported in informix ?

Jean Sagi <jeansagi_at_myrealbox.com> wrote in message news:<bfj7tu$dre$1_at_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. Received on Tue Jul 22 2003 - 19:29:52 CEST