Re: Implementing product-aggregate

Hi again,

Am Montag, 11. März 2024, 10:16:33 CET schrieb Jan Kohnert:

> create aggregate prod(numeric) (sfunc = numeric_mul, stype = numeric)

my basic idea was creating a function

create function multiply(arg1 numeric, arg2 numeric)

    returns numeric

    language sql

    immutable

    returns null on null input

    return arg1 * arg2;

and use that function instead of the undocumented numeric_mul as the sfunc in the aggregate definition.

Then again, this seems odd, too, since we're only reimplementing basic stuff that's already there.

I'm still undecided...

--

MfG Jan