> On 24 Mar 2023, at 11:26, PG Doc comments form <nore...@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
