Re: WIP: Relaxing the constraints on numeric scale

From: Robert Haas <robertmhaas(at)gmail(dot)com>
To: Dean Rasheed <dean(dot)a(dot)rasheed(at)gmail(dot)com>
Cc: PostgreSQL Hackers <pgsql-hackers(at)lists(dot)postgresql(dot)org>
Subject: Re: WIP: Relaxing the constraints on numeric scale
Date: 2021-06-29 21:00:51
Message-ID: CA+TgmoYYz37hnrHrz5aPhb73AOKRndGDnd4O=1EpRR6x4VrVbA@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

On Tue, Jun 29, 2021 at 4:46 PM Dean Rasheed <dean(dot)a(dot)rasheed(at)gmail(dot)com> wrote:
> On Tue, 29 Jun 2021 at 21:34, Robert Haas <robertmhaas(at)gmail(dot)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

In response to

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Anastasia Lubennikova 2021-06-29 21:49:30 Extensible storage manager API - smgr hooks
Previous Message Tom Lane 2021-06-29 20:55:32 Re: WIP: Relaxing the constraints on numeric scale