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';

Reply via email to