easier way to get number of rows in DELETE

[kevinburke1]

If I issue a DELETE it would be nice to know whether 0, 1, or more rows were deleted, in an easy way.

I tried doing this, FYI

DELETE FROM queued_jobs
WHERE id = $1
RETURNING count(id) as rows_deleted;

And got this at runtime (not compile time)

pq: aggregate functions are not allowed in RETURNING

[eullerpereira94]

Well this is a issue outside of sqlc, but that can be addressed trough code generation.
The Exec() method of the sql.DB type, from the database/sql package, returns two values: an sql.Result interface and an error.
The sql.Result interface has two methods: LastInsertId(), that is self-explanatory, and RowsAffected(), that returns the amount of rows that were inserted, updated, or deleted, and this is what you want.
My proposed solution is to have all generated methods that were marked with an exec tag in the generating sql script to also return a sql.Result in addition to the error.
If you can't wait for a change in the library like this, you can go use this Stack Overflow answer to solve your problem.

[eullerpereira94]

Reading better the code, I've noticed that there is a execrows tag. After testing a little, this does provides the functionality you want.

[kevinburke1]

Ah, forgot about one. Maybe the issue should be better documentation of what the meta fields do.