On Tue, 27 Jul 2021 at 17:22, Tom Lane <tgl@sss.pgh.pa.us> wrote:
>
> Simon Riggs <simon.riggs@enterprisedb.com> writes:
> > This is for migration?
>
> Yeah, compatibility with some other DBMSes that allow this.
>
> > Or does it mean very small values now occupy less space since we store
> > fewer zeros?
>
> It won't affect space consumption at all, as NUMERIC has never stored
> leading or trailing zeroes. (Modulo the fact that "zero" here means
> a base-NDIGIT digit.)
Thanks, just trying to understand what that was for.
--
Simon Riggs http://www.EnterpriseDB.com/