postgresql count deleted rows

Posted: August 28, 2019 in Uncategorized

Need to count of rows deleted in postgresql?

WITH d AS(DELETE FROM sometable WHERE somestatekey = -2 RETURNING *) SELECT COUNT(*) FROM d;

Leave a comment