主页 / dba / 问题 / 157679
Accepted
Vao Tsun
Asked: 2016-12-10 05:09:19 +0800 CST

jsonb_each_text(jsonb) 返回 jsonb，而不是文本

  • 772

根据文档，jsonb_each_text(jsonb)返回

一组键文本，值文本

但如果你pg_typeof(value)在结果上显示jsonb，例如：

SELECT *, pg_typeof(key) AS type_key, pg_typeof(value) AS type_value
FROM jsonb_each('{"2": "-200.08"}');

 key |   value   | type_key | type_value 
-----+-----------+----------+------------
 2   | "-200.08" | text     | jsonb

更新： 我把文档误认为jsonb_each_text是jsonb_each

postgresql json

1 个回答

  1. Best Answer

    jsonb_each不是jsonb_each_text

    不，您正在打电话并且您正在参考它显示jsonb_each的文档jsonb_each_text

    上\dfS json_each_text，

          Name       | Result data type |              Argument data types              |
-----------------+------------------+-----------------------------------------------+
 jsonb_each_text | SETOF record     | from_json jsonb, OUT key text, OUT value text 
 jsonb_each      | SETOF record     | from_json jsonb, OUT key text, OUT value jsonb

    进行调整以调用jsonb_each_text

    SELECT *, pg_typeof(key) AS type_key, pg_typeof(value) AS type_value
FROM jsonb_each_text('{"2": "-200.08"}');

 key |  value  | type_key | type_value 
-----+---------+----------+------------
 2   | -200.08 | text     | text
    • 1

相关问题