Re: WIP: Relaxing the constraints on numeric scale
Robert Haas <robertmhaas@gmail.com>
From: Robert Haas <robertmhaas@gmail.com>
To: Dean Rasheed <dean.a.rasheed@gmail.com>
Cc: PostgreSQL Hackers <pgsql-hackers@lists.postgresql.org>
Date: 2021-06-29T21:00:51Z
Lists: pgsql-hackers
On Tue, Jun 29, 2021 at 4:46 PM Dean Rasheed <dean.a.rasheed@gmail.com> wrote: > On Tue, 29 Jun 2021 at 21:34, Robert Haas <robertmhaas@gmail.com> wrote: > > I thought about this too, but > > http://postgr.es/m/774767.1591985683@sss.pgh.pa.us made me think that > > it would be an on-disk format break. Maybe it's not, though? > > No, because the numeric dscale remains non-negative, so there's no > change to the way numeric values are stored. The only change is to > extend the allowed scale in the numeric typemod. Ah! Well, in that case, this sounds great. (I haven't looked at the patch, so this is just an endorsement of the concept.) -- Robert Haas EDB: http://www.enterprisedb.com
Commits
-
Allow numeric scale to be negative or greater than precision.
- 085f931f5249 15.0 landed