diff options
| author | Masaya Tojo <masaya@tojo.tokyo> | 2023-03-04 19:44:11 +0900 |
|---|---|---|
| committer | Masaya Tojo <masaya@tojo.tokyo> | 2023-03-04 20:12:02 +0900 |
| commit | 85aa0f7fa89cad0cd81af87336d7f9d31bb19422 (patch) | |
| tree | 5f0b3662993798269085c6d7d3a04a00188214ac /deploy/insert_transaction.sql | |
| parent | 88b7a0784e0c9e66dad26e0d85ee06ce9f7c59b9 (diff) | |
Change insert_transaction signature to use integer.
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 $$ |