Re: documentation describing the range of a number type 'integer' is incorrect

From: Alvaro Herrera <alvherre(at)alvh(dot)no-ip(dot)org>
To: kjs(at)teews(dot)com, pgsql-docs(at)lists(dot)postgresql(dot)org
Cc: Michael Meskes <meskes(at)postgresql(dot)org>
Subject: Re: documentation describing the range of a number type 'integer' is incorrect
Date: 2021-10-22 13:43:30
Message-ID: 202110221343.rgmrpm6sy3be@alvherre.pgsql
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-docs

On 2021-Jul-29, PG Doc comments form wrote:

> https://www.postgresql.org/docs/13/datatype-numeric.html says that the range
> of a numeric type integer is -2147483648 to +2147483647 but
> PGTYPESnumeric_to_int considers -2147483648 (a perfectly valid 32-bit
> integer) to be invalid because it compares to -INT_MAX instead of INT_MIN or
> (-INT_MAX - 1). This goes back to the initial commit in the git repo for
> src/interfaces/ecpg/pgtypeslib/numeric.c. And doc/src/sgml/ecpg.sgml
> documents the min being -INT_MAX.

This sounds like an ECPG bug, not a documentation problem.

--
Álvaro Herrera 39°49'30"S 73°17'W — https://www.EnterpriseDB.com/
"XML!" Exclaimed C++. "What are you doing here? You're not a programming
language."
"Tell that to the people who use me," said XML.
https://burningbird.net/the-parable-of-the-languages/

In response to

Responses

Browse pgsql-docs by date

  From Date Subject
Next Message Euler Taveira 2021-10-22 15:20:55 Re: ALTER TABLE ... SET DATA TYPE removes statistics
Previous Message PG Doc comments form 2021-10-22 11:12:46 Update documentation page for translators