aboutsummaryrefslogtreecommitdiff
path: root/src/exchangedb
diff options
context:
space:
mode:
authorJoseph <Joseph.xu@efrei.net>2023-01-23 09:14:25 -0500
committerJoseph <Joseph.xu@efrei.net>2023-01-23 09:14:25 -0500
commit10cf3b3b65c89b3304a4d4f40c4b1a7eb5e47d14 (patch)
tree78ba9ba6a0bf7fba5b2077a0fdc0c6ae97ffc3c6 /src/exchangedb
parent54fa07f5c7be025ee1a241deabe4a5dbcca61599 (diff)
fix SQL syntax
Diffstat (limited to 'src/exchangedb')
-rw-r--r--src/exchangedb/exchange_do_insert_aml_decision.sql2
-rw-r--r--src/exchangedb/exchange_do_insert_aml_officer.sql2
2 files changed, 2 insertions, 2 deletions
diff --git a/src/exchangedb/exchange_do_insert_aml_decision.sql b/src/exchangedb/exchange_do_insert_aml_decision.sql
index 480736afa..b3f77c8c4 100644
--- a/src/exchangedb/exchange_do_insert_aml_decision.sql
+++ b/src/exchangedb/exchange_do_insert_aml_decision.sql
@@ -27,7 +27,7 @@ CREATE OR REPLACE FUNCTION exchange_do_insert_aml_decision(
OUT out_last_date INT8)
LANGUAGE plpgsql
AS $$
-
+BEGIN
-- Check officer is eligible to make decisions.
PERFORM
FROM exchange.aml_staff
diff --git a/src/exchangedb/exchange_do_insert_aml_officer.sql b/src/exchangedb/exchange_do_insert_aml_officer.sql
index 72f813e89..5cb926c07 100644
--- a/src/exchangedb/exchange_do_insert_aml_officer.sql
+++ b/src/exchangedb/exchange_do_insert_aml_officer.sql
@@ -24,7 +24,7 @@ CREATE OR REPLACE FUNCTION exchange_do_insert_aml_officer(
OUT out_last_change INT8)
LANGUAGE plpgsql
AS $$
-
+BEGIN
INSERT INTO exchange.aml_staff
(decider_pub
,master_sig