Horton

Make jsonpath .string() be immutable for datetimes.

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

View on postgr.es
Commit: cb599b9ddfccd15e77f4c167c4e5bdf1ddc3af38
Author: Tom Lane <tgl@sss.pgh.pa.us>
Date: 2024-09-12T18:30:29Z
Releases: 18.0 
Make jsonpath .string() be immutable for datetimes.

Discussion of commit ed055d249 revealed that we don't actually
want jsonpath's .string() method to depend on DateStyle, nor
TimeZone either, because the non-"_tz" jsonpath functions are
supposed to be immutable.  Potentially we could allow a TimeZone
dependency in the "_tz" variants, but it seems better to just
uniformly define this method as returning the same string that
jsonb text output would do.  That's easier to implement too,
saving a couple dozen lines.

Patch by me, per complaint from Peter Eisentraut.  Back-patch
to v17 where this feature came in (in 66ea94e8e).  Also
back-patch ed055d249 to provide test cases.

Discussion: https://postgr.es/m/5e8879d0-a3c8-4be2-950f-d83aa2af953a@eisentraut.org

Files

PathChange+/−
doc/src/sgml/func.sgml modified +3 −4
src/backend/utils/adt/jsonpath_exec.c modified +8 −26
src/test/regress/expected/jsonb_jsonpath.out modified +23 −50
src/test/regress/sql/jsonb_jsonpath.sql modified +5 −7

Documentation touched

Discussion