diff options
Diffstat (limited to 'deploy/delete_transaction.sql')
-rw-r--r-- | deploy/delete_transaction.sql | 15 |
1 files changed, 0 insertions, 15 deletions
diff --git a/deploy/delete_transaction.sql b/deploy/delete_transaction.sql deleted file mode 100644 index d3c23de..0000000 --- a/deploy/delete_transaction.sql +++ /dev/null @@ -1,15 +0,0 @@ --- 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; |