Re: Implementing product-aggregate

[Jan Kohnert]

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