| From: | Kevin Sweet <kevin(at)teews(dot)com> |
|---|---|
| To: | Alvaro Herrera <alvherre(at)alvh(dot)no-ip(dot)org>, 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 18:55:33 |
| Message-ID: | 41540ed2-5ef9-8b46-6706-9baeb58b8851@teews.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-docs |
<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(dot)rgmrpm6sy3be(at)alvherre(dot)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/datatype-numeric.html</a> 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>
| Attachment | Content-Type | Size |
|---|---|---|
| unknown_filename | text/html | 1.4 KB |
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Alvaro Herrera | 2021-10-22 19:23:50 | Re: documentation describing the range of a number type 'integer' is incorrect |
| Previous Message | Euler Taveira | 2021-10-22 15:20:55 | Re: ALTER TABLE ... SET DATA TYPE removes statistics |