Hi !

I'd like to request (and your opnion about it of course) a new aggregate
function called PRODUCT or something on that line (MULTIPLY ?):

This aggregate function will multiply every value from the records and
give the result back.

For example:
Rec # Value
1 2.0
2 3.0
3 4.0
4 0.6

Select PRODUCT(Value) from Foo
PRODUCT
========
14.4

The result is (2.0 * 3.0 * 4.0 * 0.6)

Any comments ?

--
Alexandre Benson Smith
Development
THOR Software e Comercial Ltda
Santo Andre - Sao Paulo - Brazil
www.thorsoftware.com.br