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

From: PG Doc comments form <noreply(at)postgresql(dot)org>
To: pgsql-docs(at)lists(dot)postgresql(dot)org
Cc: kjs(at)teews(dot)com
Subject: documentation describing the range of a number type 'integer' is incorrect
Date: 2021-07-29 22:27:39
Message-ID: 162759765986.25752.13395472408540963267@wrigleys.postgresql.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-docs

The following documentation comment has been logged on the website:

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

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.

Responses

Browse pgsql-docs by date

  From Date Subject
Next Message Anthony Berglas 2021-07-30 03:43:24 Re: Common case not at all clear
Previous Message Bruce Momjian 2021-07-29 22:24:17 Re: getting table name from partition