Aug 2025

2 commits
Improve tests of date_trunc() with infinity and unsupported units
7 Aug 2025Michael Paquiermaster19beta1REL_19_STABLE19beta1REL_18_STABLE18beta3Also in: Datum as struct (not this thread)
LLM analysis, 100% suremodified before commitlight changesfrom patchset #51 of 1 reviewer saw the final version

The commit takes the first patch in #5, adding only an explicit-GMT valid-unit infinity test in src/test/regress/sql/timestamptz.sql and its expected output, as explained in #7. This contradicts the from_discussion attribution in thread #52009: the matching tests are attached here, while that thread's verdict explicitly says its attachments contain neither these timestamp nor timestamptz tests.

  • Michael Paquiersaw the final versioncommittercommitted the patch
Fix incorrect Datum conversion in timestamptz_trunc_internal()
7 Aug 2025Michael Paquiermaster19beta1REL_19_STABLE19beta1REL_18_STABLE18beta3Also in: Datum as struct (not this thread)
LLM analysis, 100% surelanded as postedfrom patchset #51 of 2 reviewers saw the final version

The commit exactly matches the second patch in #5, replacing PG_RETURN_TIMESTAMPTZ(timestamp) with return timestamp in src/backend/utils/adt/timestamp.c. Attribution to thread #52009 is superseded by this matching August 6 submission, which is later than that thread's claimed source #596924 from July 31.

  • Tom Laneno review foundtrailerTom Lane is credited in #5 and 2242b26ce4, but no review activity by him appears in this thread.
  • Michael Paquiersaw the final versioncommittercommitted the patch

Dec 2024

1 commit
Improve handling of date_trunc() units for infinite input values
27 Dec 2024Michael Paquiermaster18beta1REL_19_STABLE18beta1REL_18_STABLE18beta1
LLM analysis, 100% surelanded as postedfrom patchset #11 of 1 reviewer saw the final version

d85ce012f9 matches all seven changed files in #1, including the unit-validation switches and regression tests; their stable patch IDs match.

  • Michael Paquiersaw the final versioncommittercommitted the patch

Credits across 3 commits

Author
Peter Eisentraut2
Joseph Koshakow1
Reviewer
Michael Paquiercommitter3
Tom Lane1
Committer
Michael Paquier3