model-writtenrun 6298 - may be wrong, links go to the source messages. Commit-by-commit LLM analysis is in the Commits dialog.
- Dean Rasheed proposed allowing negative numeric scales for rounding before the decimal point and scales exceeding precision for small fractional values, while keeping stored display scales non-negative #1.
- Robert Haas questioned storage compatibility #2; Dean explained that numeric storage remained unchanged #3, and Tom Lane considered external typmod consumers a manageable catalog-compatibility concern #4, after which Robert endorsed the concept while explicitly disclaiming patch review #5.
- Dean added documentation and regression tests and explained the choice of scale limits from -1000 to 1000, preserving the existing positive limit and providing a generous symmetric negative limit #6.
- Tom recommended reserving five typmod bits, using clearer helper names, documenting the historical VARHDRSZ offset, and retaining the test table for pg_upgrade coverage #7; Dean incorporated those suggestions with inline helpers and portable 11-bit sign extension #8.
- After a closer review, Tom supplied a delta that explained ordinary numeric declarations before the extended cases, centralized typmod validity checks, and used int32 consistently, declaring the result ready for commitment #9.
- Dean committed the complete patch from #8 with Tom's delta from #9, minor documentation wrapping, and a catalog-version bump as 085f931f52; his final message confirmed that everything had landed and retained the PostgreSQL 15 documentation annotation, leaving only a broader documentation-policy question #10.