All pastes #470351 Raw Edit

coulix

public sql v1 · immutable
·published 2007-05-04 06:55 UTC
rendered paste body
-- 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