Content-Length: 276029 | pFad | http://github.com/postgrespro/postgres/commit/0cc46c825135ff0feb17462398058fba00d88739

79 doc: Fix two queries related to jsonb functions · postgrespro/postgres@0cc46c8 · GitHub
Skip to content

Commit 0cc46c8

Browse files
committed
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
1 parent adc15f4 commit 0cc46c8

File tree

1 file changed

+2
-2
lines changed

1 file changed

+2
-2
lines changed

doc/src/sgml/func.sgml

Lines changed: 2 additions & 2 deletions
Original file line numberDiff line numberDiff line change
@@ -15688,7 +15688,7 @@ table2-mapping
1568815688
</para>
1568915689
<para>
1569015690
<literal>jsonb_set_lax('[{"f1":1,"f2":null},2,null,3]', '{0,f1}', null)</literal>
15691-
<returnvalue>[{"f1":null,"f2":null},2,null,3]</returnvalue>
15691+
<returnvalue>[{"f1": null, "f2": null}, 2, null, 3]</returnvalue>
1569215692
</para>
1569315693
<para>
1569415694
<literal>jsonb_set_lax('[{"f1":99,"f2":null},2]', '{0,f3}', null, true, 'return_target')</literal>
@@ -15927,7 +15927,7 @@ table2-mapping
1592715927
comparisons.
1592815928
</para>
1592915929
<para>
15930-
<literal>jsonb_path_exists_tz('["2015-08-01 12:00:00 -05"]', '$[*] ? (@.datetime() &lt; "2015-08-02".datetime())')</literal>
15930+
<literal>jsonb_path_exists_tz('["2015-08-01 12:00:00-05"]', '$[*] ? (@.datetime() &lt; "2015-08-02".datetime())')</literal>
1593115931
<returnvalue>t</returnvalue>
1593215932
</para></entry>
1593315933
</row>

0 commit comments

Comments
 (0)








ApplySandwichStrip

pFad - (p)hone/(F)rame/(a)nonymizer/(d)eclutterfier!      Saves Data!


--- a PPN by Garber Painting Akron. With Image Size Reduction included!

Fetched URL: http://github.com/postgrespro/postgres/commit/0cc46c825135ff0feb17462398058fba00d88739

Alternative Proxies:

Alternative Proxy

pFad Proxy

pFad v3 Proxy

pFad v4 Proxy