model-writtenrun 4609 - may be wrong, links go to the source messages. Commit-by-commit LLM analysis is in the Commits dialog.
- Евгений Жужнев reported that PostgreSQL 15.2 returned 442800.000000 for EXTRACT(EPOCH FROM INTERVAL '5 days 3 hours'), while the documentation showed 442800 #1.
- Tom Lane explained that the trailing zeroes were intentional after EXTRACT began returning numeric, but proposed stripping them through int64_div_fast_to_numeric and attached implementation and regression-output changes #2.
- Daniel Gustafsson favored the readability of stripped output, while Tom argued that six fractional digits represented maximum possible precision rather than known input precision; both favored avoiding a backpatch of the behavior change #3 #4 #5.
- After the behavior proposal missed v16, Tom instead committed corrections to the documented EXTRACT outputs, with backports through v14, leaving the attached implementation patch uncommitted fbbd7edca8 #6.
- Daniel subsequently favored retaining the existing behavior because it had survived two releases with few complaints, leaving the documentation mismatch resolved and any future behavior change deferred #7.