计算更新次数 [英] Count number of updates

问题描述

我有一些 postgresql 表，我想知道是否有可能计算更新的行数?

I have some postgresql tables, and I want to know if there is any possibility to count the number of updated rows?

更清楚的是能够计算表上可能发生的更新次数.

To be more clear is being able to count the number of updates that may occur on a table.

推荐答案

例如使用RETURNING:

DROP TABLE IF EXISTS t;
CREATE TABLE t(i INT);

INSERT INTO t(i) VALUES (1),(2),(3);

WITH cte AS
(
    UPDATE t
    SET i = i * 10
    WHERE i > 1
    RETURNING *   
)
SELECT COUNT(*) AS num_of_rows_updated
FROM cte;

Rextester 演示

这篇关于计算更新次数的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！