mydreambei-ai · September 29, 2016 02:40
diff --git a/pg_custom_agg.sql b/pg_custom_agg.sql
 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
 );
	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
	);