pg.ddx.io pgsql-docs@postgresql.org mailing list archive
help / color / mirror / Atom feed"jsonb ? text" operator and JSON strings
2+ messages / 2 participants
[nested] [flat]
* "jsonb ? text" operator and JSON strings
@ 2022-11-28 19:41 PG Doc comments form <noreply@postgresql.org>
2022-11-28 21:29 ` Re: "jsonb ? text" operator and JSON strings David G. Johnston <david.g.johnston@gmail.com>
0 siblings, 1 reply; 2+ messages in thread
From: PG Doc comments form @ 2022-11-28 19:41 UTC (permalink / raw)
To: pgsql-docs@lists.postgresql.org; +Cc: divergentdave@gmail.com
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.
^ permalink raw reply [nested|flat] 2+ messages in thread
* Re: "jsonb ? text" operator and JSON strings
2022-11-28 19:41 "jsonb ? text" operator and JSON strings PG Doc comments form <noreply@postgresql.org>
@ 2022-11-28 21:29 ` David G. Johnston <david.g.johnston@gmail.com>
0 siblings, 0 replies; 2+ messages in thread
From: David G. Johnston @ 2022-11-28 21:29 UTC (permalink / raw)
To: divergentdave@gmail.com; pgsql-docs@lists.postgresql.org
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.
^ permalink raw reply [nested|flat] 2+ messages in thread
end of thread, other threads:[~2022-11-28 21:29 UTC | newest]
Thread overview: 2+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2022-11-28 19:41 "jsonb ? text" operator and JSON strings PG Doc comments form <noreply@postgresql.org>
2022-11-28 21:29 ` David G. Johnston <david.g.johnston@gmail.com>
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