diff options
| author | Christian Grothoff <christian@grothoff.org> | 2022-12-08 14:20:33 +0100 |
|---|---|---|
| committer | Christian Grothoff <christian@grothoff.org> | 2022-12-08 14:20:33 +0100 |
| commit | f9cc76ad3c4d7a8c720e971a1a9cba1bb79fa974 (patch) | |
| tree | 6746712e8b0d716410d14252c7fbb3d245c6e36a /src/exchangedb/pg_select_refunds_by_coin.c | |
| parent | 329b7692ea4b09d9fb1399ad38af87b6e7486f38 (diff) | |
| parent | db34b05a772504cce4fd13c6fafec28cd0d75907 (diff) | |
Merge branch 'master' of git+ssh://git.taler.net/exchange
Diffstat (limited to 'src/exchangedb/pg_select_refunds_by_coin.c')
| -rw-r--r-- | src/exchangedb/pg_select_refunds_by_coin.c | 20 |
1 files changed, 12 insertions, 8 deletions
diff --git a/src/exchangedb/pg_select_refunds_by_coin.c b/src/exchangedb/pg_select_refunds_by_coin.c index 6510ae4a..84b63a71 100644 --- a/src/exchangedb/pg_select_refunds_by_coin.c +++ b/src/exchangedb/pg_select_refunds_by_coin.c @@ -138,15 +138,19 @@ TEH_PG_select_refunds_by_coin ( // FIXME-Joseph PREPARE (pg, "get_refunds_by_coin_and_contract", + "WITH rc AS MATERIALIZED(" "SELECT" - " ref.amount_with_fee_val" - ",ref.amount_with_fee_frac" - " FROM refunds ref" - " JOIN deposits dep" - " USING (coin_pub,deposit_serial_id)" - " WHERE ref.coin_pub=$1" - " AND dep.merchant_pub=$2" - " AND dep.h_contract_terms=$3;"); + " * FROM refunds ref" + "WHERE ref.coin_pub=$1" + "AND dep.merchant_pub=$2" + "AND dep.h_contract_terms=$3" + ")" + "SELECT" + " ref.amount_with_fee_val" + " ,ref.amount_with_fee_frac" + "FROM deposits dep" + "JOIN rc" + " USING (coin_pub,deposit_serial_id)"); } qs = GNUNET_PQ_eval_prepared_multi_select (pg->conn, "get_refunds_by_coin_and_contract", |