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