commit e5bf2ab30e6de7a003e8f3928c4edfd2453773bf
parent e3c0320132f88f3d13e1f6d96a6cea9c3334df83
Author: Christian Grothoff <christian@grothoff.org>
Date: Mon, 1 Jun 2020 14:14:38 +0200
SQL fixing
Diffstat:
1 file changed, 1 insertion(+), 3 deletions(-)
diff --git a/src/backenddb/plugin_merchantdb_postgres.c b/src/backenddb/plugin_merchantdb_postgres.c
@@ -7122,7 +7122,6 @@ libtaler_plugin_merchantdb_postgres_init (void *cls)
",picked_up_frac"
",justification"
",merchant_tips.expiration"
- // ",exchange_url"
",reserve_pub"
" FROM merchant_tips"
" JOIN merchant_tip_reserves USING (reserve_serial)"
@@ -7138,8 +7137,7 @@ libtaler_plugin_merchantdb_postgres_init (void *cls)
" pickup_id"
",amount_val"
",amount_frac"
- // ",num_planchets"
- // ",COUNT(blind_sig)"
+ ",COUNT(blind_sig) AS num_planchets"
" FROM merchant_tip_pickups"
" JOIN merchant_tip_pickup_signatures USING (pickup_serial)"
" WHERE tip_serial = $1",