On Tue, 27 Jul 2021 at 17:22, Tom Lane wrote:
>
> Simon Riggs 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 a
Simon Riggs 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. (Mo
This is for migration?
Or does it mean very small values now occupy less space since we store
fewer zeros?
Thanks
On Mon, 26 Jul 2021 at 14:17, Dean Rasheed wrote:
>
> Allow numeric scale to be negative or greater than precision.
>
> Formerly, when specifying NUMERIC(precision, scale), the scal
