diff options
| author | Christian Grothoff <christian@grothoff.org> | 2024-08-26 16:17:23 +0200 |
|---|---|---|
| committer | Christian Grothoff <christian@grothoff.org> | 2024-08-26 16:17:23 +0200 |
| commit | 4faac799b392f4278b206c5cbb42ec13953cd570 (patch) | |
| tree | 64a7e15584d82a0551308e8cd6b748c28d4330f7 /src/exchangedb | |
| parent | 337c8ca7f691b1b6295b8b4fa261bc899292ee1f (diff) | |
fix #9128
Diffstat (limited to 'src/exchangedb')
| -rw-r--r-- | src/exchangedb/pg_select_aml_attributes.c | 11 |
1 files changed, 11 insertions, 0 deletions
diff --git a/src/exchangedb/pg_select_aml_attributes.c b/src/exchangedb/pg_select_aml_attributes.c index f8a72de89..6aeb74ffd 100644 --- a/src/exchangedb/pg_select_aml_attributes.c +++ b/src/exchangedb/pg_select_aml_attributes.c @@ -145,6 +145,17 @@ TEH_PG_select_aml_attributes ( " AND kyc_attributes_serial_id > $2" " ORDER BY kyc_attributes_serial_id ASC" " LIMIT $3"); + PREPARE (pg, + "select_aml_attributes_dec", + "SELECT" + " kyc_attributes_serial_id" + ",collection_time" + ",encrypted_attributes" + " FROM kyc_attributes" + " WHERE h_payto=$1" + " AND kyc_attributes_serial_id < $2" + " ORDER BY kyc_attributes_serial_id DESC" + " LIMIT $3"); qs = GNUNET_PQ_eval_prepared_multi_select (pg->conn, stmt, params, |