diff options
Diffstat (limited to 'deploy/insert_transaction.sql')
-rw-r--r-- | deploy/insert_transaction.sql | 24 |
1 files changed, 0 insertions, 24 deletions
diff --git a/deploy/insert_transaction.sql b/deploy/insert_transaction.sql deleted file mode 100644 index eb5a38e..0000000 --- a/deploy/insert_transaction.sql +++ /dev/null @@ -1,24 +0,0 @@ --- Deploy kakeibo:insert_transaction to pg --- requires: schema --- requires: transactions - -BEGIN; - -CREATE OR REPLACE FUNCTION kakeibo.insert_transaction( - p_type_code INTEGER, - p_date DATE, - p_note TEXT -) RETURNS INTEGER AS $$ - DECLARE - inserted_id INTEGER; - BEGIN - INSERT INTO kakeibo.transactions ( - type_code, date, note - ) VALUES ( - p_type_code, p_date, p_note - ) RETURNING id INTO inserted_id; - RETURN inserted_id; - END; -$$ LANGUAGE plpgsql SECURITY DEFINER; - -COMMIT; |