Will this syntax work: fcn_stats are all in the same schema
CREATE OR REPLACE FUNCTION insert_stats(p_date date) RETURNS void AS $$ BEGIN insert into stats ( date, stats1, stats2 ) (select p_date, fcn_stats1(p_date,'basic'), fcn_stats2(p_date,'basic',0) from dual ); END; $$ LANGUAGE 'plpgsql';