-- Function: "DeleteDay"(date)

-- DROP FUNCTION "DeleteDay"(date);

CREATE OR REPLACE FUNCTION "DeleteDay"(date)
  RETURNS void AS
$BODY$DELETE FROM dashboard_orderstate WHERE order_date = $1;
DELETE FROM dashboard_orderstatesubsetarchive WHERE order_date = $1;
DELETE FROM dashboard_statistic WHERE day =$1;
$BODY$
  LANGUAGE 'sql' VOLATILE STRICT;
ALTER FUNCTION "DeleteDay"(date) OWNER TO dashboard;


================
How to call this function ?

EXECUTE FUNCTION DeleteDay("20070410"); 
does not work