commit 3e99c50c0f940fda34585225c38c9014cc1110d0
parent d04769b729a6a7153c76d56ab3764efe2ca28667
Author: Christian Grothoff <christian@grothoff.org>
Date: Sat, 4 Jun 2022 14:07:02 +0200
-fix SQL
Diffstat:
1 file changed, 5 insertions(+), 5 deletions(-)
diff --git a/src/exchangedb/plugin_exchangedb_postgres.c b/src/exchangedb/plugin_exchangedb_postgres.c
@@ -1262,13 +1262,13 @@ prepare_statements (struct PostgresClosure *pg)
"get_purse_deposit_by_coin_pub",
"SELECT"
" partner_base_url"
- ",amount_with_fee_val"
- ",amount_with_fee_frac"
+ ",pd.amount_with_fee_val"
+ ",pd.amount_with_fee_frac"
",denoms.fee_deposit_val"
",denoms.fee_deposit_frac"
- ",purse_pub"
- ",coin_sig"
- ",purse_deposit_serial_id"
+ ",pd.purse_pub"
+ ",pd.coin_sig"
+ ",pd.purse_deposit_serial_id"
",pr.refunded"
" FROM purse_deposits pd"
" LEFT JOIN partners"