Getting row count from a delete operation


It looks to me that databases currently uses fetchval instead of execute to implement it’s execute for asyncpg:

This means that you can’t get the “status line” back - “INSERT 0 1” - which would tell you how many rows have been deleted for a DELETE statement. Right now I can’t see a way to get a row count back from a delete at all. Is there any other way? Currently we’re using a work around with a differently structured SQL query (returning ids of deleted rows and then counting them).

Would this method need to be changed?