Re: error in the example given for numeric data types

jian he <jian(dot)universality(at)gmail(dot)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