diff options
Diffstat (limited to 'deploy/insert_transaction.sql')
| -rw-r--r-- | deploy/insert_transaction.sql | 3 |
1 files changed, 2 insertions, 1 deletions
diff --git a/deploy/insert_transaction.sql b/deploy/insert_transaction.sql index 851b38e..42e825d 100644 --- a/deploy/insert_transaction.sql +++ b/deploy/insert_transaction.sql @@ -4,8 +4,9 @@ BEGIN; +DROP FUNCTION kakeibo.insert_transaction(kakeibo.transaction_type, DATE, TEXT); CREATE OR REPLACE FUNCTION kakeibo.insert_transaction( - p_type kakeibo.transaction_type, + p_type INTEGER, p_date DATE, p_note TEXT ) RETURNS INTEGER AS $$ |