libeufin

commit 2e848710da3032ea739cd91a4c78b2936e5a031c
parent 70ce1cf9fb377540fe0ae3241b184651f3c23b67
Author: Antoine A <>
Date:   Tue,  2 Jan 2024 18:08:50 +0000

Simplify some SQL

Diffstat:
M
database-versioning/libeufin-bank-procedures.sql
 | 
12
++++++------

1 file changed, 6 insertions(+), 6 deletions(-)
diff --git a/database-versioning/libeufin-bank-procedures.sql b/database-versioning/libeufin-bank-procedures.sql
@@ -1061,9 +1061,9 @@ END IF;
 -- check account exists and has appropriate tan info
 SELECT 
     bank_account_id, is_taler_exchange,
-    CASE 
-      WHEN in_tan_channel = 'sms'   THEN phone
-      WHEN in_tan_channel = 'email' THEN email
+    CASE in_tan_channel
+      WHEN 'sms'   THEN phone
+      WHEN 'email' THEN email
     END
   INTO account_id, out_account_is_exchange, out_tan_info
   FROM bank_accounts
@@ -1373,9 +1373,9 @@ expired BOOLEAN;
 retransmit BOOLEAN;
 BEGIN
 -- Retreive account id
-SELECT customer_id, tan_channel, CASE 
-    WHEN tan_channel = 'sms'   THEN phone
-    WHEN tan_channel = 'email' THEN email
+SELECT customer_id, tan_channel, CASE tan_channel
+    WHEN 'sms'   THEN phone
+    WHEN 'email' THEN email
   END
 INTO account_id, out_tan_channel, out_tan_info
 FROM customers WHERE login = in_login;