在任何PostgreSQL语句上调用row_to_json（row）（甚至不返回结果的语句） [英] Call row_to_json(row) on any PostgreSQL statement (even statements that don't return a result)

问题描述

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

I'm looking for query to always return the JSON representation from PostgreSQL statement, even if there's no returning *. Here's an example:

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

无论如何说结果|| {} ？

推荐答案

使用返回以获得插入语句的结果：

Use returning to get results of insert statement:

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

这篇关于在任何PostgreSQL语句上调用row_to_json（row）（甚至不返回结果的语句）的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！