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