我希望查询总是从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

还有什么要说的吗?

最佳答案

使用returning获取insert语句的结果:

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

关于sql - 在任何PostgreSQL语句上调用row_to_json(row)(甚至不返回结果的语句),我们在Stack Overflow上找到一个类似的问题:https://stackoverflow.com/questions/41254694/

10-12 12:30
查看更多