deploy/delete_item.sql


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;