From 58c00ca515142d27e3fb324539dedd75b8740bcf Mon Sep 17 00:00:00 2001 From: Masaya Tojo Date: Tue, 28 Feb 2023 22:20:25 +0900 Subject: Add function to insert item. --- verify/insert_item.sql | 7 +++++++ 1 file changed, 7 insertions(+) create mode 100644 verify/insert_item.sql (limited to 'verify') diff --git a/verify/insert_item.sql b/verify/insert_item.sql new file mode 100644 index 0000000..dac4fba --- /dev/null +++ b/verify/insert_item.sql @@ -0,0 +1,7 @@ +-- Verify kakeibo:insert_item on pg + +BEGIN; + +SELECT has_function_privilege('kakeibo.insert_item(kakeibo.transaction_type, date, text)', 'execute'); + +ROLLBACK; -- cgit v1.2.3