Re: WIP: Relaxing the constraints on numeric scale
Tom Lane <tgl@sss.pgh.pa.us>
From: Tom Lane <tgl@sss.pgh.pa.us>
To: Dean Rasheed <dean.a.rasheed@gmail.com>
Cc: Robert Haas <robertmhaas@gmail.com>,
PostgreSQL Hackers <pgsql-hackers@lists.postgresql.org>
Date: 2021-07-23T15:50:09Z
Lists: pgsql-hackers
Attachments
- numeric-scale-v3-delta.patch (text/x-diff) patch v3
Dean Rasheed <dean.a.rasheed@gmail.com> writes: > All your other suggestions make sense too. Attached is a new version. OK, I've now studied this more closely, and have some additional nitpicks: * I felt the way you did the documentation was confusing. It seems better to explain the normal case first, and then describe the two extended cases. * As long as we're encapsulating typmod construction/extraction, let's also encapsulate the checks for valid typmods. * Other places are fairly careful to declare typmod values as "int32", so I think this code should too. Attached is a proposed delta patch making those changes. (I made the docs mention that the extension cases are allowed as of v15. While useful in the short run, that will look like noise in ten years; so I could go either way on whether to do that.) If you're good with these, then I think it's ready to go. I'll mark it RfC in the commitfest. regards, tom lane
Commits
-
Allow numeric scale to be negative or greater than precision.
- 085f931f5249 15.0 landed