Jul 2021

1 commit
Disallow negative strides in date_bin()
28 Jul 2021John Naylormaster15beta1REL_19_STABLE15beta1REL_18_STABLE15beta1REL_17_STABLE15beta1REL_16_STABLE15beta1REL_15_STABLE15beta1REL_14_STABLE14beta3
LLM analysis, 100% suremodified before commitlight changesfrom patchset #442 of 2 reviewers saw the final version

The timestamp.c changes and all four regression-file changes match #44. The commit additionally corrects doc/src/sgml/func.sgml to require positive strides, addressing Michael Paquier's review in #46.

  • Tom Lanesaw the final versiontrailerEndorsed rejecting negative strides in #45, after which only the documentation correction was added.
  • Michael Paquiersaw the final versiontrailerIdentified the contradictory documentation in #46, and John Naylor confirmed incorporating that correction in #47.

Apr 2021

2 commits
Improve behavior of date_bin with origin in the future
10 Apr 2021Peter Eisentrautmaster14beta1REL_19_STABLE14beta1REL_18_STABLE14beta1REL_17_STABLE14beta1REL_16_STABLE14beta1REL_15_STABLE14beta1REL_14_STABLE14beta1
LLM analysis, 100% surelanded as postedfrom patchset #291 of 2 reviewers saw the final version

The added lines in timestamp.c, timestamp.sql and timestamp.out match #29, including the origin > timestamp && stride_usecs > 1 condition. Peter Eisentraut confirmed committing it after discussing that condition in #33 and #36.

  • Arthur Zakirovsaw an earlier versionLLM analysis, 81% sureReported incorrect future-origin results in #15, prompting the earlier correction in #16, which was subsequently removed and reimplemented for the simplified API.
  • Peter Eisentrautsaw the final versioncommittercommitted the patch
doc: Additional documentation for date_bin
9 Apr 2021Peter Eisentrautmaster14beta1REL_19_STABLE14beta1REL_18_STABLE14beta1REL_17_STABLE14beta1REL_16_STABLE14beta1REL_15_STABLE14beta1REL_14_STABLE14beta1
LLM analysis, 100% suremodified before commitlight changesfrom patchset #302 of 2 reviewers saw the final version

Adds the synopsis and parameter descriptions from #30 to doc/src/sgml/func.sgml, with paragraph reflow and the negative-interval statement moved into its own paragraph and reworded.

  • Justin Pryzbysaw the final versionLLM analysis, 98% sureReported the missing synopsis in the committed documentation and supplied an inline proposal in #28 that became #30; the commit also credits him as Reported-by.
  • Peter Eisentrautsaw the final versioncommittercommitted the patch

Mar 2021

1 commit
Add date_bin function
24 Mar 2021Peter Eisentrautmaster14beta1REL_19_STABLE14beta1REL_18_STABLE14beta1REL_17_STABLE14beta1REL_16_STABLE14beta1REL_15_STABLE14beta1REL_14_STABLE14beta1
LLM analysis, 100% suremodified before commitmoderate changesfrom patchset #201 of 5 reviewers saw the final version

Retains the two date_bin functions and catalog definitions from #20, restores a full documentation section and expands regression coverage. It also removes the one-microsecond fast paths and fixes the timestamptz infinity return to use PG_RETURN_TIMESTAMPTZ.

  • David Fettersaw an earlier versiontrailerFound and supplied a fix for mixed-unit validation in #2 and discussed compatible mixed units in #5, before the arithmetic and API redesigns.
  • Isaac Morlandsaw an earlier versiontrailerIdentified the inconsistent weekly alignment and proposed Monday-aligned origins in #8, prompting the arithmetic rewrite.
  • Tom Lanesaw an earlier versiontrailerReviewed origin semantics, one-based fields, modulus arithmetic, BC dates and error handling in #4, before substantial implementation changes.
  • Artur Zakirovsaw an earlier versiontrailerTested fractional-year intervals in #10 and reported future-origin problems and documentation issues in #15, before the final API simplification.
  • Peter Eisentrautsaw the final versioncommittercommitted the patch

Credits across 4 commits

Author
John Naylor1 LLM4
Reviewer
Peter Eisentrautcommitter3
Tom Lane2
Arthur Zakirov1
David Fetter1
Isaac Morland1
Michael Paquier1
Reported by
Justin Pryzby1
Committer
Peter Eisentraut3
John Naylor1

N LLM means N of the credits come from LLM analysis, not from commit trailers.