diff options
author | Christian Grothoff <grothoff@gnunet.org> | 2023-10-17 11:01:20 +0200 |
---|---|---|
committer | Christian Grothoff <grothoff@gnunet.org> | 2023-10-17 11:01:20 +0200 |
commit | c741c1fa718e144548b5508e85e469ec93f73b54 (patch) | |
tree | 85141f374ac1c56bece3768c7db628cce716177a /src/exchangedb/pg_get_purse_deposit.c | |
parent | 9294f3663712dbc60da1dc575278b47e9e56c6fa (diff) | |
download | exchange-c741c1fa718e144548b5508e85e469ec93f73b54.tar.xz |
kill another dead index, beautify SQL
Diffstat (limited to 'src/exchangedb/pg_get_purse_deposit.c')
-rw-r--r-- | src/exchangedb/pg_get_purse_deposit.c | 16 |
1 files changed, 8 insertions, 8 deletions
diff --git a/src/exchangedb/pg_get_purse_deposit.c b/src/exchangedb/pg_get_purse_deposit.c index c09d7578d..cb24855a1 100644 --- a/src/exchangedb/pg_get_purse_deposit.c +++ b/src/exchangedb/pg_get_purse_deposit.c @@ -59,9 +59,7 @@ TEH_PG_get_purse_deposit ( GNUNET_PQ_result_spec_end }; - *partner_url = NULL; - /* Used in #postgres_get_purse_deposit */ PREPARE (pg, "select_purse_deposit_by_coin_pub", "SELECT " @@ -71,12 +69,14 @@ TEH_PG_get_purse_deposit ( ",age_commitment_hash" ",partner_base_url" " FROM purse_deposits" - " LEFT JOIN partners USING (partner_serial_id)" - " JOIN known_coins kc USING (coin_pub)" - " JOIN denominations USING (denominations_serial)" - " WHERE coin_pub=$2" - " AND purse_pub=$1;"); - + " LEFT JOIN partners" + " USING (partner_serial_id)" + " JOIN known_coins kc" + " USING (coin_pub)" + " JOIN denominations" + " USING (denominations_serial)" + " WHERE purse_pub=$1" + " AND coin_pub=$2;"); return GNUNET_PQ_eval_prepared_singleton_select (pg->conn, "select_purse_deposit_by_coin_pub", params, |