Re: error in the example given for numeric data types - Mailing list pgsql-general

jian he <jian.universality@gmail.com> writes:
>> practice=# create table t1(height numeric(3,5));
>> ERROR:  NUMERIC scale 5 must be between 0 and precision 3

> it works in pg15, not in pg14.
> see my test: https://dbfiddle.uk/wgfjCx7j

Indeed. The quoted documentation text is different between v15 and prior
versions.  Observe also the v15 release notes:

https://www.postgresql.org/docs/15/release-15.html

    E.4.3.4. Data Types

        Allow the scale of a numeric value to be negative, or greater than
        its precision (Dean Rasheed, Tom Lane)

        This allows rounding of values to the left of the decimal point,
        e.g., '1234'::numeric(4, -2) returns 1200.


            regards, tom lane