1 2 3 4 5 6 7 8 9 10 11 12 13 14 15
-- Deploy kakeibo:delete_item to pg -- requires: schema -- requires: items BEGIN; CREATE OR REPLACE FUNCTION kakeibo.delete_item( p_item_id INTEGER ) RETURNS VOID AS $$ BEGIN DELETE FROM kakeibo.items WHERE id = p_item_id; END; $$ LANGUAGE plpgsql SECURITY DEFINER; COMMIT;