Thread: Mistake in documentation (PG15+)

The following documentation comment has been logged on the website:

Page: https://www.postgresql.org/docs/15/datatype-numeric.html
Description:

Greetings.

Just found a mistake in documentation:

https://www.postgresql.org/docs/15/datatype-numeric.html
$$
Thus, a column declared as
NUMERIC(2, -3)
will round values to the nearest thousand and can store values between
-99000 and 99000, inclusive.
$$

But the correct range here would be from -99499 to 99499:

select 99499::NUMERIC(2, -3);

> On 24 Mar 2023, at 11:26, PG Doc comments form <noreply@postgresql.org> wrote:

> But the correct range here would be from -99499 to 99499:
>
> select 99499::NUMERIC(2, -3);

I'm not sure I see the error you indicate, numeric(2,-3) gives the range
indicated in the documentation:

postgres=# select -99499::numeric(2, -3) as neg,  99499::numeric(2, -3) as pos;
  neg   |  pos
--------+-------
 -99000 | 99000
(1 row)

--
Daniel Gustafsson