Re: "jsonb ? text" operator and JSON strings
| От | David G. Johnston |
|---|---|
| Тема | Re: "jsonb ? text" operator and JSON strings |
| Дата | |
| Msg-id | CAKFQuwYhCoUupuGgVM4DQ_ZNc4g2gVdHsdV2ct7EeQCEaUdQ1w@mail.gmail.com обсуждение исходный текст |
| Ответ на | "jsonb ? text" operator and JSON strings (PG Doc comments form <noreply@postgresql.org>) |
| Список | pgsql-docs |
On Mon, Nov 28, 2022 at 1:34 PM PG Doc comments form <noreply@postgresql.org> wrote:
The following documentation comment has been logged on the website:
Page: https://www.postgresql.org/docs/14/functions-json.html
Description:
The description of the "jsonb ? text" operator in table 9.45 specifies its
behavior when the jsonb value is an object or an array, but not when it is a
string, number, or the null JSON object. One of the examples in 8.14.3 says,
in a comment, "A string is considered to exist if it matches a primitive
JSON string". I think the behavior of the operator on each JSON primitive
type should be spelled out in prose somewhere.
I suppose we shouldn't imply it doesn't work on non-containers since it obviously does. And by fixing that omission state clearly that on a non-container existence and containment are equivalent and based upon equality.
David J.
В списке pgsql-docs по дате отправления: