Preserve tz when converting to jsonb timestamptz This removes an inconsistency in the treatment of different datatypes by the jsonpath timestamp_tz() function. Conversions from data types that are not timestamp-aware, such as date and timestamp, are now treated consistently with conversion from those that are such as timestamptz.
Author: David Wheeler Reviewed-by: Junwang Zhao and Jeevan Chalke Discussion: https://postgr.es/m/7DE080CE-6D8C-4794-9BD1-7D9699172FAB%40justatheory.com Backpatch to release 17. Branch ------ REL_17_STABLE Details ------- https://git.postgresql.org/pg/commitdiff/0d57dc2f9137de47534cc4db115e182e4093b945 Modified Files -------------- src/backend/utils/adt/jsonpath_exec.c | 25 +++++++++++++++++++++++++ src/test/regress/expected/jsonb_jsonpath.out | 4 ++-- 2 files changed, 27 insertions(+), 2 deletions(-)
