Preserve tz when converting to jsonb timestamptz

Git

Title

CI (CFBot)

Not processed

Stats (from CFBot)

Unknown

Topic

Bug Fixes

Created

2024-07-10 14:33:55

Last modified

2024-08-11 03:10:16 (7 months ago)

Latest email

2024-07-30 13:42:14 (7 months, 1 week ago)

Status

2024-09: Committed

Target version

Authors

David Wheeler (theory)

Reviewers

Zhao Junwang (zhjwpku)Become reviewer

Committer

Andrew Dunstan (adunstan)

Links

Emails

jsonpath: Inconsistency of timestamp_tz() Output: First at 2024-07-01 15:02:29 by "David E. Wheeler" <david at justatheory.com>
Latest at 2024-07-30 13:42:14 by "David E. Wheeler" <david at justatheory.com>
Latest attachment (v5-0001-Preserve-tz-when-converting-to-jsonb-timestamptz.patch) at 2024-07-22 17:29:02 from "David E. Wheeler" <david at justatheory.com>
    Attachment (v5-0001-Preserve-tz-when-converting-to-jsonb-timestamptz.patch) at 2024-07-22 17:29:02 from "David E. Wheeler" <david at justatheory.com> (Patch: Yes)
    Attachment (v4-0001-Preserve-tz-when-converting-to-jsonb-timestamptz.patch) at 2024-07-22 07:12:21 from Jeevan Chalke <jeevan.chalke at enterprisedb.com> (Patch: Yes)
    Attachment (v3-0001-Preserve-tz-when-converting-to-jsonb-timestamptz.patch) at 2024-07-19 14:05:25 from "David E. Wheeler" <david at justatheory.com> (Patch: Yes)
    Attachment (v2-0001-Preserve-tz-when-converting-to-jsonb-timestamptz.patch) at 2024-07-10 15:19:32 from "David E. Wheeler" <david at justatheory.com> (Patch: Yes)
    Attachment (v1-0001-Preserve-tz-when-converting-to-jsonb-timestamptz.patch) at 2024-07-10 14:33:05 from "David E. Wheeler" <david at justatheory.com> (Patch: Yes)

History

When	Who	What
2024-08-11 03:10:16	Zhao Junwang (zhjwpku)	Closed in commitfest 2024-09 with status: Committed
2024-08-11 03:10:16	Zhao Junwang (zhjwpku)	Changed committer to adunstan
2024-07-19 17:58:52	David Wheeler (theory)	Changed authors to David Wheeler (theory)
2024-07-10 14:34:24	David Wheeler (theory)	Changed reviewers to Zhao Junwang (zhjwpku)
2024-07-10 14:34:24	David Wheeler (theory)	Changed targetversion to 17
2024-07-10 14:34:24	David Wheeler (theory)	Changed gitlink to https://github.com/theory/postgres/pull/7
2024-07-10 14:33:56	David Wheeler (theory)	Attached mail thread 7DE080CE-6D8C-4794-9BD1-7D9699172FAB@justatheory.com
2024-07-10 14:33:55	David Wheeler (theory)	Created patch record