From 85aa0f7fa89cad0cd81af87336d7f9d31bb19422 Mon Sep 17 00:00:00 2001 From: Masaya Tojo Date: Sat, 4 Mar 2023 19:44:11 +0900 Subject: Change insert_transaction signature to use integer. --- deploy/insert_transaction.sql | 3 ++- 1 file changed, 2 insertions(+), 1 deletion(-) (limited to 'deploy/insert_transaction.sql') 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 $$ -- cgit v1.2.3