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