From 10cf3b3b65c89b3304a4d4f40c4b1a7eb5e47d14 Mon Sep 17 00:00:00 2001 From: Joseph Date: Mon, 23 Jan 2023 09:14:25 -0500 Subject: fix SQL syntax --- src/exchangedb/exchange_do_insert_aml_decision.sql | 2 +- src/exchangedb/exchange_do_insert_aml_officer.sql | 2 +- 2 files changed, 2 insertions(+), 2 deletions(-) (limited to 'src/exchangedb') 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 -- cgit v1.2.3