Re: Patch: Improve Boolean Predicate JSON Path Docs

David E. Wheeler <david@justatheory.com>

From: "David E. Wheeler" <david@justatheory.com>
To: jian he <jian.universality@gmail.com>
Cc: Erik Wienhold <ewie@ewie.name>, pgsql-hackers@lists.postgresql.org
Date: 2023-10-19T13:39:29Z
Lists: pgsql-hackers

Attachments

On Oct 19, 2023, at 01:22, jian he <jian.universality@gmail.com> wrote:

> "Do not use with non-predicate", double negative is not easy to
> comprehend. Maybe we can simplify it.
> 
> 16933:         value. Use only SQL-standard JSON path expressions, not not
> there are two "not".
> 
> 15842:         SQL-standard JSON path expressions, not not
> there are two "not”.


Thank you, jian. Updated patch attached and also on GitHub.

  https://github.com/postgres/postgres/compare/master...theory:postgres:jsonpath-pred-docs

Best,

David


Commits

  1. Doc: improve documentation for jsonpath behavior.

  2. Ensure we have a snapshot while dropping ON COMMIT DROP temp tables.