pgsql: Document behavior of the .** jsonpath accessor in the lax mode

From: Alexander Korotkov <akorotkov(at)postgresql(dot)org>
To: pgsql-committers(at)lists(dot)postgresql(dot)org
Subject: pgsql: Document behavior of the .** jsonpath accessor in the lax mode
Date: 2021-01-29 12:28:38
Message-ID: E1l5StC-0005lP-Lg@gemulon.postgresql.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-committers

Document behavior of the .** jsonpath accessor in the lax mode

When the .** jsonpath accessor handles the array, it selects both array and
each of its elements. When using lax mode, subsequent accessors automatically
unwrap arrays. So, the content of each array element may be selected twice.

Even though this behavior is counterintuitive, it's correct because everything
works as designed. This commit documents it.

Backpatch to 12 where the jsonpath language was introduced.

Reported-by: Thomas Kellerer
Bug: #16828
Discussion: https://postgr.es/m/16828-2b0229babfad2d8c%40postgresql.org
Discussion: https://postgr.es/m/CAPpHfdtS-nNidT%3DEqZbAYOPcnNOWh_sd6skVdu2CAQUGdvpT8Q%40mail.gmail.com
Author: Alexandex Korotkov, revised by Tom Lane
Reviewed-by: Alvaro Herrera, Thomas Kellerer, Tom Lane
Backpatch-through: 12

Branch
------
REL_13_STABLE

Details
-------
https://git.postgresql.org/pg/commitdiff/9915fe22969a46f9d06d6c2c53dea7269ec4cc7e

Modified Files
--------------
doc/src/sgml/func.sgml | 18 ++++++++++++++++++
1 file changed, 18 insertions(+)

Browse pgsql-committers by date

  From Date Subject
Next Message Alexander Korotkov 2021-01-29 12:28:49 pgsql: Document behavior of the .** jsonpath accessor in the lax mode
Previous Message Alexander Korotkov 2021-01-29 12:28:27 pgsql: Document behavior of the .** jsonpath accessor in the lax mode