diff options
Diffstat (limited to 'src/exchangedb/pg_select_aml_attributes.c')
| -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, |