Postgres jsonb data

Поиск
Список
Период
Сортировка
От PG Doc comments form
Тема Postgres jsonb data
Дата
Msg-id 174774849023.1455382.3103677107495562713@wrigleys.postgresql.org
обсуждение исходный текст
Список pgsql-docs
The following documentation comment has been logged on the website:

Page: https://www.postgresql.org/docs/14/datatype-json.html
Description:

Documentation suggests that a json type of null doesn't turn into anything
when read into a jsonb, because the json type of null doesn't correspond to
the postgres type of NULL.  We've found that in fact it's treated the same
as the string "null" - and the documentation probably should reflect this
edge case.
We're currently using Postgres 14, and it's possible that this has changed
in later versions, but I'm using the Postgres 14 documentation - and this is
table 8.23 in that version of the documentation (formatting doesn't copy
from the webpage into this form):
Table 8.23. JSON Primitive Types and Corresponding PostgreSQL Types
JSON primitive type     PostgreSQL type Notes
string  text    \u0000 is disallowed, as are Unicode escapes representing
characters not available in the database encoding
number  numeric NaN and infinity values are disallowed
boolean boolean Only lowercase true and false spellings are accepted
null    (none)  SQL NULL is a different concept

В списке pgsql-docs по дате отправления: