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 ------ master Details ------- https://git.postgresql.org/pg/commitdiff/524d490a9f4ab81d86bbedc6e429fbc27776351c 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(-)
