SQLize Online / PHPize Online  /  SQLtest Online

DROP FUNCTION IF EXISTS my_accum; CREATE FUNCTION my_accum(val1 float8, val2 float8) RETURNS float8 LANGUAGE plpgsql AS $function$ BEGIN RAISE NOTICE 'my_accum = %', val1; END; $function$ ; DROP FUNCTION IF EXISTS my_avg; CREATE FUNCTION my_avg(val1 float8, val2 float8) RETURNS float8 LANGUAGE plpgsql AS $function$ BEGIN RAISE NOTICE 'my_avg = %', val1; END; $function$ ; CREATE AGGREGATE avg_last (float8) ( sfunc = my_accum, stype = float8[], finalfunc = my_avg, initcond = '{0}' );