Is it possible to get the number of rows affected by a DELETE query?

[mplanchard]

If I run a DELETE query, postgres tells me the number of rows deleted, e.g.:

postgres=# delete from mytable where id = 'foobar';
DELETE 0

Is it possible to get the number of rows affected back from a sqlx query in some way?

[mplanchard]

Ah, I found it. For postgres, at least, there's a .rows_affected() method on the PgQueryResult that comes back from an operation, which is the Ok variant of the Result returned by e.g. the .execute() future, so like:

let rows_affected = query!("DELETE FROM mytable").execute(cxn).await.unwrap().rows_affected()