diff options
| -rw-r--r-- | doc/src/sgml/func.sgml | 32 | ||||
| -rw-r--r-- | doc/src/sgml/ref/release_savepoint.sgml | 4 |
2 files changed, 18 insertions, 18 deletions
diff --git a/doc/src/sgml/func.sgml b/doc/src/sgml/func.sgml index 92a0f49e6a1..ebcd936acb6 100644 --- a/doc/src/sgml/func.sgml +++ b/doc/src/sgml/func.sgml @@ -17725,28 +17725,28 @@ ERROR: jsonpath member accessor can only be applied to an object The unwrapping behavior of lax mode can lead to surprising results. For instance, the following query using the <literal>.**</literal> accessor selects every <literal>HR</literal> value twice: - <screen> - <prompt>=></prompt> <userinput>select jsonb_path_query(:'json', 'lax $.**.HR');</userinput> - jsonb_path_query - ------------------ - 73 - 135 - 73 - 135 - </screen> +<screen> +<prompt>=></prompt> <userinput>select jsonb_path_query(:'json', 'lax $.**.HR');</userinput> + jsonb_path_query +------------------ + 73 + 135 + 73 + 135 +</screen> This happens because the <literal>.**</literal> accessor selects both the <literal>segments</literal> array and each of its elements, while the <literal>.HR</literal> accessor automatically unwraps arrays when using lax mode. To avoid surprising results, we recommend using the <literal>.**</literal> accessor only in strict mode. The following query selects each <literal>HR</literal> value just once: - <screen> - <prompt>=></prompt> <userinput>select jsonb_path_query(:'json', 'strict $.**.HR');</userinput> - jsonb_path_query - ------------------ - 73 - 135 - </screen> +<screen> +<prompt>=></prompt> <userinput>select jsonb_path_query(:'json', 'strict $.**.HR');</userinput> + jsonb_path_query +------------------ + 73 + 135 +</screen> </para> <para> diff --git a/doc/src/sgml/ref/release_savepoint.sgml b/doc/src/sgml/ref/release_savepoint.sgml index e9fc6e5d1c8..6c616aaf999 100644 --- a/doc/src/sgml/ref/release_savepoint.sgml +++ b/doc/src/sgml/ref/release_savepoint.sgml @@ -116,8 +116,8 @@ BEGIN; now only choose one of these two commands, since all other commands will be ignored: <programlisting> - ROLLBACK; - ROLLBACK TO SAVEPOINT sp1; +ROLLBACK; +ROLLBACK TO SAVEPOINT sp1; </programlisting> Choosing <command>ROLLBACK</command> will abort everything, including value 1, whereas <command>ROLLBACK TO SAVEPOINT sp1</command> will retain |