From: Kevin Sweet <kevin@teews.com>
To: Alvaro Herrera <alvherre@alvh.no-ip.org>
To: pgsql-docs@lists.postgresql.org
Cc: Michael Meskes <meskes@postgresql.org>
Subject: Re: documentation describing the range of a number type 'integer' is incorrect
Date: Fri, 22 Oct 2021 11:55:33 -0700
Message-ID: <41540ed2-5ef9-8b46-6706-9baeb58b8851@teews.com> (raw)
In-Reply-To: <202110221343.rgmrpm6sy3be@alvherre.pgsql>
References: <202110221343.rgmrpm6sy3be@alvherre.pgsql>
<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=UTF-8">
</head>
<body>
<font face="Arial">The bugs team agreed that it's a bug. The
documentation accurately represents the buggy code. I thought you
might want to update the doc when the bug is fixed.<br>
<br>
</font><br>
<div class="moz-cite-prefix">On 10/22/21 6:43 AM, Alvaro Herrera
wrote:<br>
</div>
<blockquote type="cite"
cite="mid:202110221343.rgmrpm6sy3be@alvherre.pgsql">
<pre class="moz-quote-pre" wrap="">On 2021-Jul-29, PG Doc comments form wrote:
</pre>
<blockquote type="cite">
<pre class="moz-quote-pre" wrap=""><a class="moz-txt-link-freetext" href="https://www.postgresql.org/docs/13/datatype-numeric.html">https://www.postgresql.org/docs/13/...; 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.
</pre>
</blockquote>
<pre class="moz-quote-pre" wrap="">
This sounds like an ECPG bug, not a documentation problem.
</pre>
</blockquote>
<br>
</body>
</html>
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-docs@postgresql.org
Cc: kevin@teews.com, alvherre@alvh.no-ip.org, pgsql-docs@lists.postgresql.org, meskes@postgresql.org
Subject: Re: documentation describing the range of a number type 'integer' is incorrect
In-Reply-To: <41540ed2-5ef9-8b46-6706-9baeb58b8851@teews.com>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox