diff options
| author | Michael Paquier <michael@paquier.xyz> | 2022-09-03 20:57:23 +0900 |
|---|---|---|
| committer | Michael Paquier <michael@paquier.xyz> | 2022-09-03 20:57:23 +0900 |
| commit | 4209126655ccac68fe582c5fea3e638a4a1c503c (patch) | |
| tree | d93359398327b9b6eaebc00d6c15434d268b1b85 | |
| parent | a3e88e5a099eed5577771110b6824b376d5a44ae (diff) | |
| download | postgresql-4209126655ccac68fe582c5fea3e638a4a1c503c.tar.gz postgresql-4209126655ccac68fe582c5fea3e638a4a1c503c.zip | |
doc: Fix two queries related to jsonb functions
These have been updated by the revert done in 2f2b18b, but the
pre-revert state was correct. Note that the result was incorrectly
formatted in the first case.
Author: Erik Rijkers
Discussion: https://postgr.es/m/13777e96-24b6-396b-cb16-8ad01b6ac130@xs4all.nl
Backpatch-through: 13
| -rw-r--r-- | doc/src/sgml/func.sgml | 4 |
1 files changed, 2 insertions, 2 deletions
diff --git a/doc/src/sgml/func.sgml b/doc/src/sgml/func.sgml index 28990ec66d2..379b2135a36 100644 --- a/doc/src/sgml/func.sgml +++ b/doc/src/sgml/func.sgml @@ -16294,7 +16294,7 @@ table2-mapping </para> <para> <literal>jsonb_set_lax('[{"f1":1,"f2":null},2,null,3]', '{0,f1}', null)</literal> - <returnvalue>[{"f1":null,"f2":null},2,null,3]</returnvalue> + <returnvalue>[{"f1": null, "f2": null}, 2, null, 3]</returnvalue> </para> <para> <literal>jsonb_set_lax('[{"f1":99,"f2":null},2]', '{0,f3}', null, true, 'return_target')</literal> @@ -16533,7 +16533,7 @@ table2-mapping comparisons. </para> <para> - <literal>jsonb_path_exists_tz('["2015-08-01 12:00:00 -05"]', '$[*] ? (@.datetime() < "2015-08-02".datetime())')</literal> + <literal>jsonb_path_exists_tz('["2015-08-01 12:00:00-05"]', '$[*] ? (@.datetime() < "2015-08-02".datetime())')</literal> <returnvalue>t</returnvalue> </para></entry> </row> |