Re: jsonpath: Inconsistency of timestamp_tz() Output

David E. Wheeler <david@justatheory.com>

From: "David E. Wheeler" <david@justatheory.com>

To: Junwang Zhao <zhjwpku@gmail.com>

Cc: PostgreSQL Hackers <pgsql-hackers@lists.postgresql.org>

Date: 2024-07-10T15:19:32Z

Lists: pgsql-hackers

Commits

Same data as JSON: GET /api/v1/messages/:b64id/commits the thread's linked commits as JSON, with link sources. API reference →

Fix comment in libpqrcv_check_conninfo().
- 629520be5f9d 18.0 cited
Remove useless extern keywords
- 3fb59e789dd9 18.0 cited

Attachments

v2-0001-Preserve-tz-when-converting-to-jsonb-timestamptz.patch (application/octet-stream) patch v2-0001
(unnamed) (text/plain)

On Jul 10, 2024, at 10:54, David E. Wheeler <david@justatheory.com> wrote:

> So it should be -7, not -8. Not sure where to tell it to pay proper attention to daylight savings time.

Oh, and the time and date were wrong, too, because I blindly used the same conversion for dates as for timestamps. Fixed in v2.

PR: https://github.com/theory/postgres/pull/7
CF: https://commitfest.postgresql.org/49/5119/

Best,

David