Re: SQL construct not supported in informix ?
From: Jean Sagi <jeansagi_at_myrealbox.com>
Date: Thu, 24 Jul 2003 01:13:38 -0500
Message-ID: <bfls8b$upv$1_at_terabinaries.xmission.com>
>
>
> Yes, I have used it on 9.3 and 9.4.
>
>
>
>
> Yes, the "table(multiset(" will usually (or maybe even always?) result
> in a temp table.
>
>
>
>
> Probably a matter of taste.
>
>
>
>
> 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.
>
>
Date: Thu, 24 Jul 2003 01:13:38 -0500
Message-ID: <bfls8b$upv$1_at_terabinaries.xmission.com>
Thanks, usefull information.
Chucho!
Kristofer Andersson wrote:
> 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.
>
>
-- Atte, Jesús Antonio Santos Giraldo jeansagi_at_myrealbox.com jeansagi_at_netscape.net sending to informix-listReceived on Thu Jul 24 2003 - 08:13:38 CEST