[ANN] V4RB mac 2.1 b13 uploaded

[Ruslan Zasukhin]

On 12/8/05 3:37 AM, "Ed Kleban" <Ed at Kleban.com> wrote:

>> ***** NEW ******
>> 
>> * Added Aggregate Functions, i.e should be used with GROUP BY.
>>     
>>         STDDEV()
>>         bit_and()
>>         bit_or()
>>         bit_xor()
>> 
> 
> And presumably bit_not(x,y) and bit_count(x) as well?
> 
> I'm not sure how any of these other than STDDEV and possibly bit_count(x)
> might qualify as Aggregate functions.   What does it mean to use bit_and()
> as an aggregate?

SELECT f1, count(f1), bit_and(f1)
FROM T 
GROUP BY f1


So everything as for other aggregate functions:

GROUP BY f1, split your table to some groups.
Then for each group is applied function.

As I see, this is useful only for small groups, because you can easy get all
bits ON for big groups.

And I think to use them, it needs to have SPECIAL data in table.


-- 
Best regards,

Ruslan Zasukhin
VP Engineering and New Technology
Paradigma Software, Inc

Valentina - Joining Worlds of Information
http://www.paradigmasoft.com

[I feel the need: the need for speed]