Re: WIP: Relaxing the constraints on numeric scale - Mailing list pgsql-hackers

From Robert Haas
Subject Re: WIP: Relaxing the constraints on numeric scale
Date
Msg-id CA+TgmoYYz37hnrHrz5aPhb73AOKRndGDnd4O=1EpRR6x4VrVbA@mail.gmail.com
Whole thread Raw
In response to Re: WIP: Relaxing the constraints on numeric scale  (Dean Rasheed <dean.a.rasheed@gmail.com>)
Responses Re: WIP: Relaxing the constraints on numeric scale
List 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



pgsql-hackers by date:

Previous
From: Tom Lane
Date:
Subject: Re: WIP: Relaxing the constraints on numeric scale
Next
From: Anastasia Lubennikova
Date:
Subject: Extensible storage manager API - smgr hooks