exchange

Base system with REST service to issue digital coins, run by the payment service provider
Log | Files | Refs | Submodules | README | LICENSE
commit 10cf3b3b65c89b3304a4d4f40c4b1a7eb5e47d14
parent 54fa07f5c7be025ee1a241deabe4a5dbcca61599
Author: Joseph <Joseph.xu@efrei.net>
Date:   Mon, 23 Jan 2023 09:14:25 -0500

fix SQL syntax

Diffstat:

Msrc/exchangedb/exchange_do_insert_aml_decision.sql | 2+-


Msrc/exchangedb/exchange_do_insert_aml_officer.sql | 2+-


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
@@ -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
@@ -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