From 76b934b219b6ec82f58a7e95cbc6fff4f4ed0ebf Mon Sep 17 00:00:00 2001
From: Christian Grothoff <christian@grothoff.org>
Date: Sat, 22 Apr 2023 02:54:55 +0200
Subject: -misc fixes

---
 src/exchangedb/exchange_do_reserves_in_insert.sql | 54 +++++++++++------------
 1 file changed, 25 insertions(+), 29 deletions(-)

(limited to 'src/exchangedb')

diff --git a/src/exchangedb/exchange_do_reserves_in_insert.sql b/src/exchangedb/exchange_do_reserves_in_insert.sql
index dd202a2ae..6cd5847df 100644
--- a/src/exchangedb/exchange_do_reserves_in_insert.sql
+++ b/src/exchangedb/exchange_do_reserves_in_insert.sql
@@ -145,14 +145,12 @@ LANGUAGE plpgsql
 AS $$
 DECLARE
   curs_reserve_exist REFCURSOR;
+DECLARE
+  k INT8;
 DECLARE
   curs_transaction_exist REFCURSOR;
 DECLARE
   i RECORD;
-DECLARE
-  r RECORD;
-DECLARE
-  k INT8;
 BEGIN
   transaction_duplicate0 = TRUE;
   transaction_duplicate1 = TRUE;
@@ -228,35 +226,33 @@ BEGIN
 
   OPEN curs_transaction_exist FOR
   WITH reserve_transaction AS (
-  INSERT INTO reserves_in
-    (reserve_pub
-    ,wire_reference
-    ,credit_val
-    ,credit_frac
-    ,exchange_account_section
-    ,wire_source_h_payto
-    ,execution_date)
-    VALUES
-    (in0_reserve_pub
-    ,in0_wire_ref
-    ,in0_credit_val
-    ,in0_credit_frac
-    ,in0_exchange_account_name
-    ,in0_wire_source_h_payto
-    ,in0_execution_date),
-    (in1_reserve_pub
-    ,in1_wire_ref
-    ,in1_credit_val
-    ,in1_credit_frac
-    ,in1_exchange_account_name
-    ,in1_wire_source_h_payto
-    ,in1_execution_date)
+    INSERT INTO reserves_in
+      (reserve_pub
+      ,wire_reference
+      ,credit_val
+      ,credit_frac
+      ,exchange_account_section
+      ,wire_source_h_payto
+      ,execution_date)
+      VALUES
+      (in0_reserve_pub
+      ,in0_wire_ref
+      ,in0_credit_val
+      ,in0_credit_frac
+      ,in0_exchange_account_name
+      ,in0_wire_source_h_payto
+      ,in0_execution_date),
+      (in1_reserve_pub
+      ,in1_wire_ref
+      ,in1_credit_val
+      ,in1_credit_frac
+      ,in1_exchange_account_name
+      ,in1_wire_source_h_payto
+      ,in1_execution_date)
     ON CONFLICT DO NOTHING
     RETURNING reserve_pub)
   SELECT reserve_pub FROM reserve_transaction;
 
-  FETCH FROM curs_transaction_exist INTO r;
-
   k=0;
   <<loop_transaction>> LOOP
     FETCH FROM curs_transaction_exist INTO i;
-- 
cgit v1.2.3