From: PG Doc comments form <noreply@postgresql.org>
To: pgsql-docs@lists.postgresql.org
Cc: divergentdave@gmail.com
Subject: "jsonb ? text" operator and JSON strings
Date: Mon, 28 Nov 2022 19:41:38 +0000
Message-ID: <166966449818.1903.16619777695754736362@wrigleys.postgresql.org> (raw)
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.
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-docs@postgresql.org
Cc: noreply@postgresql.org, pgsql-docs@lists.postgresql.org, divergentdave@gmail.com
Subject: Re: "jsonb ? text" operator and JSON strings
In-Reply-To: <166966449818.1903.16619777695754736362@wrigleys.postgresql.org>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox