U_SUMMARIZE: how aggregate is calculated?

From: Mikito Harakiri <mikharakiri_at_iahu.com>
Date: Wed, 1 Dec 2004 15:19:43 -0800
Message-ID: <8vsrd.22$N87.90_at_news.oracle.com>

Suppose we have one column relation which is essentially a set of intervals:

{[1,2], [3,5], [4,7]}

and I want to project away the interval column and calculate aggregated value of SUM(1). What the result there would be? 3? 2? 7? Received on Thu Dec 02 2004 - 00:19:43 CET

This message: [ Message body ]
Next message: --CELKO--: "Floyd's algorithm in SQL"
Previous message: Paul: "Re: Logical equivalence of simple and complex types under the relational model?"
Next in thread: Alfredo Novoa: "Re: U_SUMMARIZE: how aggregate is calculated?"
Reply: Alfredo Novoa: "Re: U_SUMMARIZE: how aggregate is calculated?"
Reply: Mikito Harakiri: "Re: U_SUMMARIZE: how aggregate is calculated?"
Reply: Jonathan Leffler: "Re: U_SUMMARIZE: how aggregate is calculated?"

Contemporary messages sorted: [ by date ] [ by thread ] [ by subject ] [ by author ]

Original text of this message