在任何 PostgreSQL 语句（甚至不返回结果的语句）上调用 row_to_json(row)

我正在寻找始终从 PostgreSQL 语句返回 JSON 表示的查询，即使没有returning *。这是一个例子：

WITH result AS (insert into users("name", age) values('drew', 42))
select row_to_json(row) from result as row;

现在我得到：

WITH query "result" does not have a RETURNING clause

还是有什么可说的result || {}?

Use returning获取插入语句的结果：

with result as (
    insert into users("name", age) 
    values('drew', 42)
    returning *
)
select row_to_json(row) 
from result as row;