blob: 38b3083e5ebcd87dab9c7e96d6fec18f5c3c0aeb (
about) (
plain)
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;
|