diff options
| author | Joseph <Joseph.xu@efrei.net> | 2023-01-23 09:14:25 -0500 |
|---|---|---|
| committer | Joseph <Joseph.xu@efrei.net> | 2023-01-23 09:14:25 -0500 |
| commit | 10cf3b3b65c89b3304a4d4f40c4b1a7eb5e47d14 (patch) | |
| tree | 78ba9ba6a0bf7fba5b2077a0fdc0c6ae97ffc3c6 | |
| parent | 54fa07f5c7be025ee1a241deabe4a5dbcca61599 (diff) | |
fix SQL syntax
| m--------- | contrib/gana | 0 | ||||
| -rw-r--r-- | src/exchangedb/exchange_do_insert_aml_decision.sql | 2 | ||||
| -rw-r--r-- | src/exchangedb/exchange_do_insert_aml_officer.sql | 2 |
3 files changed, 2 insertions, 2 deletions
diff --git a/contrib/gana b/contrib/gana -Subproject 7884adf99ec4d5ccf52b1a5a251b99fb6ab9c2f +Subproject 3e659ed54023230dd45dbec5664f176e1763d26 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 |