projects / postgresql.git / commit
? search:
summary | shortlog | log | commit | commitdiff | tree
(parent: 71795d1) | patch
Preserve tz when converting to jsonb timestamptz
authorAndrew Dunstan <andrew@dunslane.net>
Tue, 30 Jul 2024 11:57:16 +0000 (07:57 -0400)
committerAndrew Dunstan <andrew@dunslane.net>
Tue, 30 Jul 2024 11:57:16 +0000 (07:57 -0400)
commit0d57dc2f9137de47534cc4db115e182e4093b945
tree65ad3d6b0de870335a51f04b1e60353cd67af4fftree
parent71795d1cb41b8144ae8b84bee1e60cfc8321cfd1commit | diff
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.
src/backend/utils/adt/jsonpath_exec.c diff | blob | blame | history
src/test/regress/expected/jsonb_jsonpath.out diff | blob | blame | history
This is the main PostgreSQL git repository.