Re: Patch: Improve Boolean Predicate JSON Path Docs

Tom Lane <tgl@sss.pgh.pa.us>

From: Tom Lane <tgl@sss.pgh.pa.us>
To: "David E. Wheeler" <david@justatheory.com>
Cc: Erik Wienhold <ewie@ewie.name>, pgsql-hackers@lists.postgresql.org
Date: 2024-01-19T21:22:09Z
Lists: pgsql-hackers
I wrote:
> I experimented with

> SELECT '
>   ... multiline json value ...
> ' AS json
> \gexec

> but that didn't seem to work either.  Anybody have a better idea?

Oh, never mind, \gset is what I was reaching for.  We can make
it work with that.

			regards, tom lane



Commits

  1. Doc: improve documentation for jsonpath behavior.

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