create or replace function lmy(first INTEGER,item INTEGER) returns INTEGER as $$
BEGIN
  return first * item;
END;
$$
LANGUAGE plpgsql;

create aggregate yml(INTEGER) (
  sfunc = lmy,stype = INTEGER,initcond = 1
);

isnp=# select i,yml(i) over (order by i) from generate_series(1,10) i;