diff options
Diffstat (limited to 'src/exchangedb/exchange_do_expire_purse.sql')
-rw-r--r-- | src/exchangedb/exchange_do_expire_purse.sql | 7 |
1 files changed, 3 insertions, 4 deletions
diff --git a/src/exchangedb/exchange_do_expire_purse.sql b/src/exchangedb/exchange_do_expire_purse.sql index 2d9f7e095..1a17869ad 100644 --- a/src/exchangedb/exchange_do_expire_purse.sql +++ b/src/exchangedb/exchange_do_expire_purse.sql @@ -35,12 +35,11 @@ SELECT purse_pub ,in_reserve_quota INTO my_purse_pub ,my_in_reserve_quota - FROM exchange.purse_requests + FROM purse_requests WHERE (purse_expiration >= in_start_time) AND (purse_expiration < in_end_time) AND - purse_pub NOT IN (SELECT purse_pub - FROM purse_decision) - ORDER BY purse_expiration ASC + NOT was_decided + ORDER BY purse_expiration ASC LIMIT 1; out_found = FOUND; IF NOT FOUND |