Re: Mistake in documentation (PG15+)

From: Daniel Gustafsson <daniel(at)yesql(dot)se>
To: akdmnnakdm(at)gmail(dot)com, Pg Docs <pgsql-docs(at)lists(dot)postgresql(dot)org>
Subject: Re: Mistake in documentation (PG15+)
Date: 2023-03-24 12:38:19
Message-ID: 73EB06C8-B07E-4241-B041-CCA59C47DEF3@yesql.se
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-docs

> On 24 Mar 2023, at 11:26, PG Doc comments form <noreply(at)postgresql(dot)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

In response to

Browse pgsql-docs by date

  From Date Subject
Next Message PG Doc comments form 2023-03-24 15:10:37 List Tables
Previous Message PG Doc comments form 2023-03-24 10:26:27 Mistake in documentation (PG15+)